Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Storing Set Analysis Values into a QVD

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

Tags (2)
7 Replies
Employee
Employee

Re: Storing Set Analysis Values into a QVD

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 ?

Re: Storing Set Analysis Values into a QVD

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.


talk is cheap, supply exceeds demand
kranthi239
New Contributor

Re: Storing Set Analysis Values into a QVD

Hi,

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

Re: Storing Set Analysis Values into a QVD

You could store them like:

store TableName into TableName.txt (txt);

- Marcus

kranthi239
New Contributor

Re: Storing Set Analysis Values into a QVD

Hi Marcus,

I mean UI Table chart to .txt file; 

Re: Storing Set Analysis Values into a QVD

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
Valued Contributor

Re: Storing Set Analysis Values into a QVD

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

QVD from set analysis is not possible

Community Browser