12 Replies Latest reply: Jan 11, 2018 11:17 AM by Zied Ahmed

# percentage in bar chart

Hello,

I wloud like to display these values in percentage..is it possible ? :

• ###### Re: percentage in bar chart

sum(YourMeasure) / sum(total YourMeasure)

• ###### Re: percentage in bar chart

Omar - is there an option to select relative in Qlik Sense like we have in Qlik View?

• ###### Re: percentage in bar chart

Nope !

• ###### Re: percentage in bar chart

no we don't have @sunny

• ###### Re: percentage in bar chart

what are u searching for then?

U'll be marking ur own answer as correct as always? hahahaha

• ###### Re: percentage in bar chart

Thanks Omar just we need to add num to have percentage :

num (sum(YourMeasure) / sum(total YourMeasure),'# #0,00%')

• ###### Re: percentage in bar chart

oh hell no !! u can always use formats qlik offers  if u use this as a measure !

no need to use the num ()

ps: I won't repeat this to u ever again

• ###### Re: percentage in bar chart

Zied, if u want to keep also the numbers;

do as follow:

YourDimension&': '& aggr(sum(YourMeasure),YourDimension)

with that, u'll have the percentage on the bar, and the number besides each dimension

• ###### Re: percentage in bar chart

Thanks Omar,

I changed the set analysis and kept the simple dimension

• ###### Re: percentage in bar chart

for those who want to display that like me in the first attempt :

=Aggr(

YourDimension &' '&

num( (count(YourMeasure)

/

count( Total YourMeasure)),'# ##0,00%')

, YourDimension )

• ###### Re: percentage in bar chart

if I were I'll add {<YourDimension>} or else, when u select a dimension, u'll have 100%

I mean, sthing like this:

=Aggr(

YourDimension &' '&

num( (count(YourMeasure)

/

count( Total {<YourDimension>} YourMeasure)),'# ##0,00%')

, YourDimension )

• ###### Re: percentage in bar chart

Ok I get you