How to use 'IN' operator with 'variable' in Qlik S... - Qlik Community

vsabbise · ‎2018-10-08

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.

kenphamvn · ‎2018-10-08

Hi

You can using Exists script function

for more detail and example please see

Regards

An Pham

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