Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor III

Intersection Bar Chart

Hi Community,

I want to create a Bar chart with 2 Bars, 1 shows me a distinct number of articles sold in a specific month (Jan - Dec). Now i want a second bar that shows the number of articles sold in e.g. Dec and Jan, which would be placed on Jan. On Feb i want a bar that shows Intersection of articles of Jan and Feb and so on!

I hope this explanation gives a good view of what i want.

Thanks in advance!

Regards

Chris

1 Solution

Accepted Solutions
MVP
MVP

Re: Intersection Bar Chart

If you want in front -end you could try expression like:

Count(If(SubStringCount(Aggr( NODISTINCT Above(Concat(Product,';')), Month), Product)>0, Product))

PFA

15 Replies
Not applicable

Re: Intersection Bar Chart

can u give me example on this..to understand req good

MVP
MVP

Re: Intersection Bar Chart

Yes it gives a view, however, it would be even better if you could share a sample qvw explaining the expected output.

igdrazil
Contributor III

Re: Intersection Bar Chart

So i say we sold in Jan article           a, b, c, d

in Feb we sold                                 b,c,e

Bar1 shows on Jan: count = 4;  on Feb count = 3

Bar2 shows on Jan: count = 0 (because we have no data on Dec); and on Feb count = 2 (because there are 2 overlapping articles)

Hope this gives you further explanations

Regards

Chris

MVP
MVP

Re: Intersection Bar Chart

May be like this sample?

igdrazil
Contributor III

Re: Intersection Bar Chart

I'm working in Qlik Sense, so i'll not get any visualization in this... do you have a .qvf file for me?

Regards

Chris

igdrazil
Contributor III

Re: Intersection Bar Chart

I am able to do this whole thing in a KPI where i have a specific month given, but i can't make it work in a Bar Chart, cause of the Dimension given from it.

Formula for KPI:

count({$<Month={$(vMonth1)}>}Distinct ArticleSold)

+ count({$<Month={$(vMonth2)}>}Distinct ArticleSold)

- count({$<Month={$(vMonth2), $(vMonth1)}>}Distinct ArticleSold)

Regards

Chris

MVP
MVP

Re: Intersection Bar Chart

PFA

MVP
MVP

Re: Intersection Bar Chart

This doesn't work in chart, because your comparison in set analysis works outside chart and not row-wise.

igdrazil
Contributor III

Re: Intersection Bar Chart

Yes, i know that. That's why i'm asking here for help. I posted this formula, only for interest or more ideas

Regards

Chris

Community Browser