topic Re: using exists function to load qvd as optimized load ? in QlikView

using exists function to load qvd as optimized load ?

veeranj — Thu, 09 Aug 2018 09:25:15 GMT

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

Re: using exists function to load qvd as optimized load ?

kfoudhaily — Thu, 09 Aug 2018 09:48:03 GMT

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

Re: using exists function to load qvd as optimized load ?

veeranj — Thu, 09 Aug 2018 09:49:24 GMT

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

Re: using exists function to load qvd as optimized load ?

kfoudhaily — Thu, 09 Aug 2018 09:54:34 GMT

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,

Re: using exists function to load qvd as optimized load ?

arvind1494 — Thu, 09 Aug 2018 09:55:45 GMT

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