Need Percentage Bar Chart by Employee & Category.

[MuraliPrasath]

Hi Qlik,

I need to create a bar chart as a percentage distribution.

I've two dimensions Employee & Category and measure Total Hours.

I wanted to show a bar chart with each employee's share percentage of total hours by Category.

I tried the below measure but only works when I select any Employee. I need help on this thanks.

aggr(sum({$}[Hours])
/
sum(total{$} [Hours]), [Category])

Please refer the below screenshot. only I select the Employee then it works.

[justISO · Accepted solution]

Hi, maybe you want to use 'Relative numbers' modifier in this case? It will do the same without formula writing. Good example: https://youtu.be/3fz_2Iy500U

[MuraliPrasath]

Thank you 🙂 This one exactly worked for me. 🤝