topic Re: Upload qvd in QlikView

Upload qvd

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

anyone pls upload a qvd where you have done many set analysis work like flags and so on.

its for my reference purpose.

Regards,

Joshua.

Re: Upload qvd

avinashelite — Wed, 20 Apr 2016 05:49:44 GMT

for your information set analysis won't work in the Qlikview script .....you need to use the conditional and transformation functions to create the flags and finally you need to store the same for your qvd.

Hope this helps you

Re: Upload qvd

ajsjoshua — Wed, 20 Apr 2016 05:52:12 GMT

sorry instead of script i written set analysis

post some qvd.

Re: Upload qvd

avinashelite — Wed, 20 Apr 2016 05:56:37 GMT

Try like this , you could create your own QVD

Country:

LOAD * Inline

[

Country,Amount

India,1000

USA,500

UK,900

];

Result:

LOAD * , If(Amount>500,1,0) as Amount_Flag

resident

Country;

Drop table Country;

Store table Result into Country.qvd(QVD);

Re: Upload qvd

sunny_talwar — Wed, 20 Apr 2016 08:27:52 GMT

check the document available at this link -> Set Analysis: syntaxes, examples

Some other useful links:

Dates in Set Analysis

Excluding values in Set Analysis

A Primer on Set Analysis