Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vkish16161
Creator III
Creator III

Where Exists clarification - QVD optimized while field is concatenated

Temp:

load * inline [

Country_Year_Exists

USA-2015

IND-2018];

FACT:

load * inline [

Country,Year,Sales

USA,2015,100

USA,2016,200

IND,2018,150

IND,2019,200

GBP,1991,100]

where Exists(Country_Year_Exists,Country&'-'&Year);

Can someone explain if this'll still retain the Optimized QVD load?



hicrwunderlich

1 Solution

Accepted Solutions
marcus_sommer

Only with a single parameter will a where exists(FIELD) keep a qvd-load optimized and everything else will force a processing of the data and therefore an unoptimized load.

- Marcus

View solution in original post

1 Reply
marcus_sommer

Only with a single parameter will a where exists(FIELD) keep a qvd-load optimized and everything else will force a processing of the data and therefore an unoptimized load.

- Marcus