topic Re: percentage in bar chart in Management & Governance

percentage in bar chart

zied_ahmed1 — Thu, 11 Jan 2018 15:22:01 GMT

Hello,

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

omarbensalem‌

Re: percentage in bar chart

OmarBenSalem — Thu, 11 Jan 2018 15:23:38 GMT

sum(YourMeasure) / sum(total YourMeasure)

Re: percentage in bar chart

sunny_talwar — Thu, 11 Jan 2018 15:24:52 GMT

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

Re: percentage in bar chart

OmarBenSalem — Thu, 11 Jan 2018 15:27:22 GMT

Nope !

Re: percentage in bar chart

zied_ahmed1 — Thu, 11 Jan 2018 15:28:27 GMT

no we don't have @sunny

My first try was this :

Re: percentage in bar chart

OmarBenSalem — Thu, 11 Jan 2018 15:29:01 GMT

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

OmarBenSalem — Thu, 11 Jan 2018 15:29:43 GMT

what are u searching for then?

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

Re: percentage in bar chart

zied_ahmed1 — Thu, 11 Jan 2018 15:44:40 GMT

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

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

Re: percentage in bar chart

zied_ahmed1 — Thu, 11 Jan 2018 15:49:16 GMT

Thanks Omar,

I changed the set analysis and kept the simple dimension

Re: percentage in bar chart

OmarBenSalem — Thu, 11 Jan 2018 15:49:42 GMT

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_ahmed1 — Thu, 11 Jan 2018 15:59:20 GMT

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

OmarBenSalem — Thu, 11 Jan 2018 16:05:17 GMT

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

zied_ahmed1 — Thu, 11 Jan 2018 16:17:53 GMT

Ok I get you