Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER 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
Partner
Partner

sum(YourMeasure) / sum(total YourMeasure)

View solution in original post

12 Replies
OmarBenSalem
Partner
Partner

sum(YourMeasure) / sum(total YourMeasure)

View solution in original post

sunny_talwar

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

OmarBenSalem
Partner
Partner

Nope !

zied_ahmed1
Specialist
Specialist
Author

no we don't have @sunny

My first try was this :

first_try.PNG

OmarBenSalem
Partner
Partner

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
Partner
Partner

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
Partner
Partner

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