Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ashley33
Contributor II
Contributor II
‎2021-06-07 02:15 AM

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 🙂

203 Views
0 Likes
1 Reply
Jayavignesh
Contributor III
Contributor III
‎2021-06-07 03:15 AM

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' ?

175 Views
0 Likes