Discussion board where members can get started with Qlik Sense.
Hi guys, this should be easy oneI have seen this is a relatively common question though I am struggling to make my bar chart 100% stacked and wonder if you can help. This is my desired chart output
My dimensions are
and measure is
and its working as a stacked chart, but I cant figure out how to make it 100% so I can compare user to user
Go to Solution.
Or may be this:
Sum(AgentCall)/Sum(Total <User> AgentCall)
may be like this
change number format to %
If that doesn't work, try totaling over your top dimension:
sum(AgentCall)/sum(Total <User> AgentCall)
Thank you guys, Sunny T and Michaels answer worked for me (sorry it only seems to let me mark one as a correct answer)
I almost had it though the closest I got was
Sum(AgentCall)/Sum(Total <statusdescription> AgentCall)