Qlik Community

Qlik Sense Deployment & Management

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

zied_ahmed1
Contributor III

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
Esteemed Contributor

Re: percentage in bar chart

sum(YourMeasure) / sum(total YourMeasure)

12 Replies
OmarBenSalem
Esteemed Contributor

Re: percentage in bar chart

sum(YourMeasure) / sum(total YourMeasure)

MVP
MVP

Re: percentage in bar chart

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

OmarBenSalem
Esteemed Contributor

Re: percentage in bar chart

Nope !

zied_ahmed1
Contributor III

Re: percentage in bar chart

no we don't have @sunny

My first try was this :

first_try.PNG

OmarBenSalem
Esteemed Contributor

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

OmarBenSalem
Esteemed Contributor

Re: percentage in bar chart

what are u searching for then?

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

zied_ahmed1
Contributor III

Re: percentage in bar chart

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



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

zied_ahmed1
Contributor III

Re: percentage in bar chart

Thanks Omar,

I changed the set analysis and kept the simple dimension

OmarBenSalem
Esteemed Contributor

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

Capture.PNG

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

Community Browser