Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
niha
Creator II
Creator II

pull data from a QVD using a list of filtered values

Hello,

I need answer of the question below.

 

  1. Show us the most efficient way to pull data from a QVD using a list of filtered values

Regards,

Niha

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

your most efficient method will be 

to load a table with the values list 

than use exists in the QVD call , that way the qvd load will stay optimized 

if we assume Field1 is the field you use to filter .

your script should look like this : 

filterTable:

load Filed1

From filterList

 

Fact :

load *

from fact.qvd

where exists(Field1);

niha
Creator II
Creator II
Author

Thanks. I am able to understand second part where exist function but I am bit confused with first one. If we are calling  fact qvd with where exist function, the way it should be done is as follows:

1, Pull fact table and then convert to qvd. 

What is load a Table with valued list? 

Sorry I need to understand the first part.

Regards,

Niha