topic Re: Display overlapping data only in QlikView

Display overlapping data only

Tue, 30 Sep 2014 13:34:18 GMT

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:

Company	Product	On Hand
Comp1	A	12
Comp1	B	2
Comp1	C	4
Comp2	A	30
Comp3	B	1
Comp3	D	22

My Reporting Table should then look like this:

Company	Product	On Hand
Comp1	A	12
Comp2	A	30
Comp1	B	2
Comp3	B	22

Any help would be greatly appreciated.

Thanks,

Wynand.

Re: Display overlapping data only

giakoum — Tue, 30 Sep 2014 13:42:30 GMT

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

Re: Display overlapping data only

JonnyPoole — Tue, 30 Sep 2014 13:44:37 GMT

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)

Re: Display overlapping data only

anbu1984 — Tue, 30 Sep 2014 14:15:08 GMT

Check this

Re: Display overlapping data only

giakoum — Tue, 30 Sep 2014 14:20:38 GMT

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