Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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