Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

Placing % of a number beside the interger total

High guys on the below charts is the there anyway I can place the percentage of the number beside my total on the bars

5 Replies
cosminao
Partner - Contributor
Partner - Contributor

Hi,

You have 2 expression: Sum(exp1); Sum(exp2); You have to uncheck Values on data point.

You can add a new expression:

NUM(sum(exp1)+sum(exp2),'#,###')&' '&NUM((sum(exp1)+sum(exp2))/(sum(sum(TOTAL exp1)+sum(TOTAL exp2)),'#,###.00%'). And to uncheck Bar and check Values on data point.


Good luck!

Anil_Babu_Samineni

I don't see any difficult here, Can you attach sample application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vvvvvvizard
Partner - Specialist
Partner - Specialist

In expression =Dual(%expression , your normal expression )

enable show values on data points

trdandamudi
Master II
Master II

The below link will help with an example:

sum and percentage in a same bar chart | Qlik Community

qlikwiz123
Creator III
Creator III

Go to Chart Properties, Under Number tab, select the Expression and change it to Number and Enable 'Show in Percent'

You can change the Format pattern according to your decimal precision needed.