Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rena
Contributor
Contributor

Filter data where in a table

Hi all, I would like to know how to load data when we want to filter like this

-------------------------

where A_column in (select * from table_01 )

-------------------------

by using Qlik script

 

Thanks!

Labels (2)
1 Reply
Filippo_Nicolussi_P

Hello 

 

You could preload in a temp table the "Temp: select the_field_in_table_01_of _interest as A_column from datasource_table_01;  then use a where exists(A_column) ;  

Here a similar blog  regarding exists() usage https://community.qlik.com/t5/QlikView-App-Dev/Where-exists-function/td-p/27614  

and the official help https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe...

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!