Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lrdrogerio
Contributor
Contributor

How can I show only the values that are intersected in columns from 2 tables?

I'm using a Pivot table and I have 2 columns that should have the same names.

I'm creating a dashboard to show the products sales summaries, and I want to only show the values that are present in both columns.

I'm sure I"ll have to use set analysis but I couldn't make it yet.

1 Reply
andrey_krylov
Specialist
Specialist

Hi Rogerio. Try this set analysis

Sum({< [Field1] = {$(=Chr(34)&Concat(DISTINCT [Field2], '","')&Chr(34))} >} Amount)

[Field1] and [Field2] - the columns with the same values