percentage in bar chart

[zied_ahmed1]

Hello,

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

omarbensalem‌

[OmarBenSalem · Accepted solution]

sum(YourMeasure) / sum(total YourMeasure)

[sunny_talwar]

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

[OmarBenSalem]

Nope !

[zied_ahmed1]

no we don't have @sunny

My first try was this :

[OmarBenSalem]

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

[OmarBenSalem]

what are u searching for then?

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

[zied_ahmed1]

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

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

[zied_ahmed1]

Thanks Omar,

I changed the set analysis and kept the simple dimension

[OmarBenSalem]

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