topic Re: Expression Values Distribution (in %) over Dimension in QlikView

Expression Values Distribution (in %) over Dimension

bohsaly_mohamad_24 — Fri, 14 Feb 2020 09:33:03 GMT

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

Re: Expression Values Distribution (in %) over Dimension

Brett_Bleess — Wed, 11 Mar 2020 16:28:20 GMT

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