How to use 'IN' operator with 'variable' in Qlik Sense

vsabbise — Mon, 08 Oct 2018 22:52:24 GMT

I need to display/List the ID's of the files which has corresponding combination of key words.

I can easily achieve this in SQL using in and '=' operator. How do I do that in Qlik Sense ? I can also use Join in SQL to achieve this.

Example:

select id

from table_A

where

filename in ( select filename from table_A where keyword = 'vkeyword1' )

and

filename in ( select filename from table_A where keyword = 'vkeyword2' )

vkeyword1 & wkeyword2 are input fields that are entered dynamically by the user.

Re: How to use 'IN' operator with 'variable' in Qlik Sense

kenphamvn — Tue, 09 Oct 2018 00:32:12 GMT

You can using Exists script function

for more detail and example please see

Regards

An Pham