Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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