Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
vkish16161
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Where Exists clarification - QVD optimized while field is concatenated

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

1 Reply
MVP & Luminary
MVP & Luminary

Re: Where Exists clarification - QVD optimized while field is concatenated

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