Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display overlapping data only

Good Day,

I am trying to create a table that would display overlapping data ONLY. I have multiple companies selling similar products. I want to display in a table only the products that are being sold by both companies.

Data example:

CompanyProductOn Hand
Comp1A12
Comp1B

2

Comp1C4
Comp2A30
Comp3B1
Comp3D22

My Reporting Table should then look like this:

CompanyProductOn Hand
Comp1A12
Comp2A30
Comp1B2
Comp3B22

Any help would be greatly appreciated.

Thanks,

Wynand.

4 Replies
giakoum
Partner - Master II
Partner - Master II

not very clear what you need.

you have 3 companies in the table and there is no product that all 3 of them sell.

Please clarify

JonnyPoole
Employee
Employee

Try this expression in a chart with Product as the dimension

if (  count( DISTINCT Company) > 1, count(DISTINCT Company))

(chart on left i think is what you want)

Capture.PNG.png

anbu1984
Master III
Master III

Check this

giakoum
Partner - Master II
Partner - Master II

ok so I guess by both you mean more than 1 company. Jonathan's solution should do it.