topic Re: Need Percentage Bar Chart by Employee & Category. in App Development

Need Percentage Bar Chart by Employee & Category.

MuraliPrasath — Mon, 05 Dec 2022 06:15:04 GMT

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.

Re: Need Percentage Bar Chart by Employee & Category.

justISO — Mon, 05 Dec 2022 06:42:48 GMT

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

Re: Need Percentage Bar Chart by Employee & Category.

MuraliPrasath — Mon, 05 Dec 2022 07:30:56 GMT

Thank you 🙂 This one exactly worked for me. 🤝