Upload qvd

[ajsjoshua]

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.

[avinashelite]

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

[ajsjoshua]

sorry instead of script i written set analysis

post some qvd.

[avinashelite]

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);

[sunny_talwar]

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