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.
