sum according to the value of a dimension - Qlik Community

Ven6 · ‎2020-05-11

Hello I have a pivot table resembling the one above
Status, Family Under family and nature its dimensions and NP, ED, VD are the facts.

my concern:
I would like to create a Histogram which allows to compare the number of NP, ED and VD to the UP and the number of NP, ED and VD to the DESCENT.

how to calculate the different sum up and down and display them in the histogram

Brett_Bleess · ‎2020-06-04

I would start with the following:

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

You will likely need this one too:

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.