Tuesday, 19 June 2012

Back door access to your Qlikview report

So you're working on a Qlikview document and then the next day you can't open it
 
We've all been there, maybe you're playing around with the relationships in your data.  Saved your work and then you open it and the charts trying to generate crashes your pc.
Or maybe you’ve been working on a report all day, got your data right and take it home to make your charts and your laptop hasn’t picked up a license from the server before you left.

Here’s a couple of ways you can save your reports and a quick note on limiting other people’s access to your data.

Graphs not loading on opening

Your report won’t open as your graphs are generating – you can tell if this is happening if a loading screen appears on one of your graphs, followed by the rest of the window greying out and becoming non-responsive.
 
What you really need to do is open your report without any data and this is really easily done.
 
image
On the start page, right click the report causing you trouble and click “Open Without Data” and that’s it!

 

 

Graphs not opening between sheets

The previous step is great if your entire document is stuck, however it can be a bit overkill if it’s only one graph on one sheet that doesn’t stop the document being opened.
 
In this case, I’d suggest changing the properties of your chart without opening the sheet and causing the chart to try and load.
 
First, select Settings> Document Properties



image


Then select Sheets> the sheet> the chart and then click properties.  You can then fix the chart without opening the sheet.

Can’t access your Qlikview Data

This happened to me last weekend, I spent hours working on getting my data right only to get home in the evening and have this pop up when I tried to open it.

I left it until Monday as the report wasn’t urgent but if you REALLY need that data, you can pull the data straight out of the report.
 
First, you need to create a new Qlikview document, then in your load script select load from a Qlikview File.


image

Select the file you want to get the data from and the script generated will look like this.
image



Binary Loads will take all your data across, including your table relationships so you can create charts exactly as you would in your original document.  Then copy and paste them back into the original when you get back to the office!
SNAGHTML1239f21

Preventing Binary Loads

I don’t know about you, Binary loads worry me a little bit when it comes to data security.  
 
You can prevent Binary loads on your document by going to Settings> Document Properties> Opening and checking “Prohibit Binary Load”
















Note: Apologies if some of the images in this post are a bit grainy, I wrote this post in live writer and the image uploads seem to lose their resolution.