Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
KHSDM
Creator II
Creator II

Percentage on Value Points

H5PHIvBc5s.png

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?

Labels (1)
  • Chart

2 Solutions

Accepted Solutions
vinieme12
Champion III
Champion III

Use the Expression Modifiers instead

qlikCommunity1.PNG

then change the below Option to "Relative"

qlikCommunity1.PNG

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

Andrea_Spinetti
Creator III
Creator III

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. 

example stacked barchart.png

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 😊

 

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

6 Replies
vinieme12
Champion III
Champion III

Use Dual()

=Dual(Num(sum(Amount)/sum(Total Amount),'#,##0.00%') ,  sum(Amount) )

in Number formatting choose "Measure expression"

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
KHSDM
Creator II
Creator II
Author

Use this in the measure expression? I tried, but cannot get it.

 

EeJMEChlCl.png

vinieme12
Champion III
Champion III

please post the expression you used

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
KHSDM
Creator II
Creator II
Author

dual(Num(Count(distinct [ID])/Count(distinct TOTAL [ID]), '#,##0%'), count(distinct [ID]))

vinieme12
Champion III
Champion III

Use the Expression Modifiers instead

qlikCommunity1.PNG

then change the below Option to "Relative"

qlikCommunity1.PNG

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Andrea_Spinetti
Creator III
Creator III

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. 

example stacked barchart.png

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 😊

 

If the issue is solved please mark the answer with Accept as Solution.