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: 
davyqliks
Specialist
Specialist

Use a lookup to filter data loaded in main table

I have a 'Main Table with the field [Account code]

In that loaded data there are many [Account code] linked to the sales data. I only want to load the sales data in the main table where Exists [Account Code] in a separate load including the [Allowed Account Codes].

Main table to only load [Account Code] if that [Account Code] exists in the lookup with [Allowed Account Codes].

 

Can anybody assist please?

Thank you

 

Labels (2)
1 Solution

Accepted Solutions
davyqliks
Specialist
Specialist
Author

Thank you for this insight. 

 

View solution in original post

2 Replies
anushree1
Specialist II
Specialist II

Please use EXISTS function to get this requirement in place.

You could have  a quick read of it in the Qlikview Help 

davyqliks
Specialist
Specialist
Author

Thank you for this insight.