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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashley33
Contributor II
Contributor II

Please help :) Expression to display common items from 2 displayed tables on the same qliksense page

Dear All,

 

I have loaded table 1 in script to display user filters (located on left screen) which is used to display ITEMS with Stock <= 90 Table 

I have loaded a second separate table 2 filters (located on right screen) which is used to display ITEMS with Stock > 365

Can you please tell me a set expression to display the intersection or common items between the above two tables so that i can display a 3rd below table showing common item names?

Ashley33_0-1623046442803.png

Thank you for your help 🙂

Labels (1)
1 Reply
Jayavignesh
Contributor III
Contributor III

Can you try creating a flag column in both the tables and write a calculated dimension to display items if both the flag is set to 'Y' ?