using exists function to load qvd as optimized load ?

[veeranj]

Hi All ,

I have a qvd where in i need only few records related to the field,Country=INDIA .

There are multiple values in the field COUNTRY like INDIA,US,AUS etc.

In my dashboard,i have to load only INDIA related data  .

I followed the below approach to filter the INDIA data  and make the load as optimized load .

Data:

load * inline

[Country

INDIA

];

Load * from QVDfile where exists(Country) ;

i created one inline so that i can use exists function while loading qvd .

This will make the load as optimized load and if i use where Country=INDIA,it will not be of optimized load .

Can anyone let me know is this the right way to do it ??

Thanks.

Veera/Anjee

[kfoudhaily]

Load * from QVDfile where Country='INDIA' ; // loads only records where contry=INDIA

Load * from QVDfile where match(Country, 'INDIA','US') // loads only records for contry=india or us

[veeranj]

I am aware of that where clause . But while loading i want the load to be optimized while filtering .

[kfoudhaily]

this should work then:

TEMP:

LOAD * INLINE [

Country

INDIA

];

Load * from QVDfile Where EXISTS (Country) ;

DROP Table TEMP ;

please check this articlee:

QlikTip#: Keep Optimized QVD Load

regards,

[arvind1494]

IF YOU USE CONDITIONAL LOADING STATEMENTS THEN IT IS UN-OPTIMISED LOAD.

FOLLOWING STATEMENTS:

EXISTS,IF,WHERE

FOR YOUR NEED IF YOU NEED ONLY INDIA DATA THEN

DO IT IN 2 STEPS:

1.:

DATA:

LOAD * FROM QVDFILE WHERE Country = 'INDIA';

Store DATA into (qvd);

Now in your new app load :

Load * from (qvd);