topic Re: Save data already loaded in QlikView

Save data already loaded

marwen_garwachi — Tue, 24 May 2016 15:57:20 GMT

Hello,

Is it possible to store a data which is already loaded ? I need to reload a a dashboard (after changing the script) containning last month data but i lost last month data sources.

Do someone have a solution ?

Thanks in advance

Re: Save data already loaded

swuehl — Tue, 24 May 2016 16:05:23 GMT

You can consider using a partial reload (have a look at the script for the options) or exporting the historic data to QVD, then create your new dashboard with all data.

Storing all tables in Qlikview file to QVD

Re: Save data already loaded

marwen_garwachi — Tue, 24 May 2016 16:07:56 GMT

Thanks for your resoponse, i'ill try it !

Re: Save data already loaded

Colin-Albert — Tue, 24 May 2016 16:11:50 GMT

You could save a copy of your original QVW and then use that in a binary load (load from QlikView Files) to bring in the old data.

You can also then use a store command to save the data to QVDs.

A binary load must be the first line of your load script.

Re: Save data already loaded

MarcoWedel — Tue, 24 May 2016 18:33:26 GMT

You can also generate qvds interactively from within your application.

Create a straight table having all required fields as dimensions, no expression and deselect the "suppress zero-values" option in the presentation tab.

Then use the chart export function and select "QlikView data fiel (*.qvd)" as export format.

hope this helps

regards

Marco

Re: Save data already loaded

marwen_garwachi — Wed, 25 May 2016 09:08:00 GMT

Thanks a lot !