topic Presenting chart bars as 100% value in QlikView

Presenting chart bars as 100% value

Sat, 10 Nov 2012 00:27:51 GMT

Hi there, I have created the chart below and I'm struggling to get the bars to be represented as a 100% value.

I have added the expression below - any suggestions?

Thanks

Rob

Expression

=Sum({$<Source_Key={1}>}Ans_Percent)/q1_total_sum_perc

Variable - q1_total_sum_perc

=sum ({$<Source_Key={1}>}Ans_Percent)

MayilVahanan — Sat, 10 Nov 2012 00:52:45 GMT

Try like this

sum(ur expression) / sum(total ur expression)

Ex:

Sum(sales)/sum(total sales

Hope it helps

Sat, 10 Nov 2012 01:19:33 GMT

Hi Mayil, I tried that but wanted to check that I have it right as the result is a bit strange.

I created a variable VarDivPerc which was my expression

=Sum({$<Source_Key={1}>}Ans_Percent)/q1_total_sum_perc

Then applied your suggestion

=Sum(VarDivPerc)/ Sum(TOTAL VarDivPerc)

It came out like this!

whiteline — Sat, 10 Nov 2012 08:40:18 GMT

Hi.

It seems you don't have to discard the dimension totally as you want the ratios for each division:

=Sum({$<Source_Key={1}>} Ans_Percent)/Sum({$<Source_Key={1}>} TOTAL<Division_Name> Ans_Percent)

And the way you use the variables isn't suitable for this case as it's calculated ONCE for the whole chart.

If you remove the equal sign the content of the variable will be substituted into your expression.

Sat, 10 Nov 2012 20:06:49 GMT

That is excellent, it has worked.

Much appreciated everyone.