Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
veeranj
Creator II
Creator II

using exists function to load qvd as optimized load ?

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

4 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

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

QlikView Qlik Sense consultant
veeranj
Creator II
Creator II
Author

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

kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant
arvind1494
Specialist
Specialist

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