Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

100% stacked bar chart

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

User

statusdescription

and measure is

sum(AgentCall)

and its working as a stacked chart, but I cant figure out how to make it 100% so I can compare user to user

Thanks guys

1 Solution

Accepted Solutions
Highlighted

Or may be this:

Sum(AgentCall)/Sum(Total <User> AgentCall)

View solution in original post

4 Replies
Highlighted
Master III
Master III

may be like this

sum(AgentCall)/sum(Total AgentCall)


change number format to %

Highlighted

Or may be this:

Sum(AgentCall)/Sum(Total <User> AgentCall)

View solution in original post

Highlighted
Specialist
Specialist

Matt,

If that doesn't work, try totaling over your top dimension:

sum(AgentCall)/sum(Total <User> AgentCall)

Highlighted
Contributor III
Contributor III

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)


Instead of

Sum(AgentCall)/Sum(Total <User> AgentCall)



Thanks again