Showing/grouping hierarchy/multiple dimensions in Combo Chart

[Mancunia]

Hi,

I'd appreciate some help with a problem I'm having with the Combo Chart.

In the example below, I have some store IDs which I need grouped by the store category, a higher dimension. Unfortunately, it simply repeats each store category dimension for each store ID dimension value, and where the store ID isn't part of that category, it puts it as a null/zero value.

Is there any way I can use the higher dimension as a grouping dimension, and only show the relevant store IDs for each store category?

Thank you - help would be much appreciated!

[Brett_Bleess · Accepted solution]

Suspect this requires Set Analysis, but I am not a Development Expert by any means, check the following links, may get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Otherwise will likely be helpful if you can attach QVW file, so folks can have a more detailed look at the data model and object with expressions.

Regards,
Brett