topic Re: Use a lookup to filter data loaded in main table in QlikView

Use a lookup to filter data loaded in main table

davyqliks — Sat, 16 Nov 2024 03:44:21 GMT

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

Re: Use a lookup to filter data loaded in main table

anushree1 — Mon, 29 Apr 2019 07:03:49 GMT

Please use EXISTS function to get this requirement in place.

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

Re: Use a lookup to filter data loaded in main table

davyqliks — Mon, 29 Apr 2019 10:30:45 GMT

Thank you for this insight.