topic Re: Storing Set Analysis Values into a QVD in QlikView

Storing Set Analysis Values into a QVD

Wed, 11 Mar 2015 16:08:22 GMT

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

Re: Storing Set Analysis Values into a QVD

JonnyPoole — Wed, 11 Mar 2015 17:24:11 GMT

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

Gysbert_Wassenaar — Wed, 11 Mar 2015 17:30:56 GMT

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.

Re: Storing Set Analysis Values into a QVD

kranthi239 — Mon, 08 Oct 2018 11:45:24 GMT

Hi,

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

Re: Storing Set Analysis Values into a QVD

marcus_sommer — Tue, 09 Oct 2018 10:45:59 GMT

You could store them like:

store TableName into TableName.txt (txt);

- Marcus

Re: Storing Set Analysis Values into a QVD

kranthi239 — Tue, 09 Oct 2018 11:29:23 GMT

Hi Marcus,

I mean UI Table chart to .txt file;

Re: Storing Set Analysis Values into a QVD

marcus_sommer — Tue, 09 Oct 2018 15:36:16 GMT

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

Re: Storing Set Analysis Values into a QVD

passionate — Tue, 09 Oct 2018 15:40:38 GMT

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

QVD from set analysis is not possible