I'm trying to get my stacked bar chart to display as a percentage. I'm able to get the proper count values to display in the chart, but can't figure out what expression i would use to turn them into a percentage.
That did get me to 100%; however, not the exact result I'm looking for. I apologize, let me try and clarify the request.
For PrepQualityScore there are two values. Either Acceptable or Unacceptable. When I create a stacked bar chart with Dimension as Name and PrepQualityScore and with a Measure =Count(distinct Procedure), I get something like the following:
I guess the break up of the bar is exactly the same percentage, but Qlik Sense thus far doesn't show the numbers for each stack of the bar chart. Is the goal to get those percentages displayed in the stack bar chart?
That would be ideal; however, I'd settle for being able to see the graph displayed as a 100% and see both Acceptable and Unacceptable stacked. Then if I clicked on either result, I could see the specific percentage. OR, I could create a reference line so I could quickly tell of Acceptable was above 90%. (Still researching the reference line, but I'm pretty sure it's possible.)
Your initial expression got me to 100% for each name, but it doesn't show the split between Acceptable and Unacceptable. This is where I'm stuck.
What is the easiest way to share? I can't export the whole app as it contains some sensitive information. I'll work on seeing if I can get this data stripped from the load so I can export unless there is an easier way to share?