Expression Values Distribution (in %) over Dimensi... - Qlik Community

bohsaly_mohamad_24 · ‎2020-02-14

Dear concerned, I have a bar chart (horizontal view) having cyclical dimensions. How can I make the range of values between 0 and 100% for each item in the dimension? In other words, I want to calculate the individual totals in % rather than being relevant to the whole total. Attached is an annotated image. Thanks, Mohamad

Brett_Bleess · ‎2020-03-11

Have a look at the following Design Blog post, I think it may put you on the right track:

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

If you want to search the other posts in this area, use this link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

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.

Expression Values Distribution (in %) over Dimension