Condition for qvd

jagannalla — Sat, 23 Jul 2011 07:47:27 GMT

Hi,

I want to retrive the data based on conditon for qvd file.

For eg:

Load X,Y,Z fom XYZ.qvd;

if A contains the data from 10 to 50. i want to retrive the data from 20 to 30 only when it is loading.

i.e like between conditon...

Load X,Y,Z fom XYZ.qvd where A between 20 and 30

disqr_rm — Sun, 24 Jul 2011 23:06:21 GMT

You can load min and max values of A first and based on that you can then load the data.

Something like:

LOAD max(A) as MaxA,

min(A) as MinA

FROM XYZ.qvd(qvd)

GROUP By 1;

Then using peek you can load MaxA and MinA values:

LET vMax = peek('MaxA');

LET vMin = peek('MinA');

Then finally load your data by putting if conditions for vMax and vMin variables.

If vMin = 10 and vMax = 50 then

Load X,Y,Z fom XYZ.qvd (qvd) where A >= 20 and A <= 30;

else

Load X,Y,Z fom XYZ.qvd (qvd);

endif

Is this something would help you?

Rakesh

topic Condition for qvd in QlikView