Storing Set Analysis Values into a QVD

[#1]

I'm wondering if it is possible to store some values that are derived from Set Analysis into a qvd?

Currently, we have around 10 text boxes that contain values and we want them to be stored into a qvd every day when the .qvw is ran on a daily basis. I know this is something that is possible for a single value without the set analysis.

Is this something that's possible?

Thanks in advance.

Andrew

[JonnyPoole]

i haven't seen a way to do this. Set Analysis is valid in UI expressions only and QVDs are generated with the script statement 'store' only.

there is a good chance you can do a for loop in the script to produce an array of QVDs based on different values.

would that be of interest ?

[Gysbert_Wassenaar]

Not directly. In the script you can store data into a qvd. But in the script you cannot use set analysis. You will have to create a straight table or pivot table with your set analysis expressions. You can export this table to excel or a text file. You can next load that file in a Qlikview document and store the data in a qvd file.

[kranthi239]

Hi,

Is there a way where I can export data into txt file through script.

[marcus_sommer]

You could store them like:

store TableName into TableName.txt (txt);

- Marcus

[kranthi239]

Hi Marcus,

I mean UI Table chart to .txt file; 

[marcus_sommer]

If you could use macros (won't work within the AJAX client) you could export charts into various fileformats - just search here for macros + export.

- Marcus

[passionate]

Use Nprinting to capture daily KPI and store reports of NPrinting at a location.

QVD from set analysis is not possible