Intersection Bar Chart

[igdrazil]

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

[tresesco]

Have you checked the qvf attached above?

[igdrazil]

Yes that would work.

I thought of a way to do this only via set Analysis, but i think this won't work because we got no access on the dimension through set Analysis.

Thank you for this!

Regards

Chris

[tresesco · Accepted solution]

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

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

PFA

[igdrazil]

This looked like correct in first look, then i added a few more data rows and on 3 i got a wrong value

PFA

Regards

Chris

[tresesco]

You used wrong expression. Just copy and paste the expression from above.

[igdrazil]

Yeah nice! now it works!!!

Thank you very much!