Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

percentage in bar chart

Hello,

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

percentage.PNG

omarbensalem

1 Solution

Accepted Solutions
OmarBenSalem

sum(YourMeasure) / sum(total YourMeasure)

View solution in original post

12 Replies
OmarBenSalem

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
Specialist
Specialist
Author

no we don't have @sunny

My first try was this :

first_try.PNG

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
Specialist
Specialist
Author

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



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

zied_ahmed1
Specialist
Specialist
Author

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 ()

Capture.PNG

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