This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a stacked bar chart with the value labels enabled... but instead of the actual value, I want it to show the percentage. How can I do it?
Use the Expression Modifiers instead
then change the below Option to "Relative"
View solution in original post
Hello @KHSDM, another option is to add the % expression in the tooltips so when you over the stacked bar you will get the % of that bar like in the screenshot attached.
In the chart:
- Go to Appearance>Tooltip.
- Untoggle the selector and set it to "Custom".
- Set in exrpession: Sum(UnitID) / Sum(TOTAL<[YearMonth]> UnitID)
- Set the format as "number" and choose the % format.
You can check the attached sample App 😊
=Dual(Num(sum(Amount)/sum(Total Amount),'#,##0.00%') , sum(Amount) )
in Number formatting choose "Measure expression"
Use this in the measure expression? I tried, but cannot get it.
please post the expression you used
dual(Num(Count(distinct [ID])/Count(distinct TOTAL [ID]), '#,##0%'), count(distinct [ID]))