topic Re: Help With Text In Chart Expression Formatting Percentage in QlikView

Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:12:49 GMT

Hello:

I have a Funnel chart where under the Presentation tab, I'm attempting to add an expression in the Text in Chart section and append the output to some text as a percentage in XX% format. However, I can't quite seem to get there. The end result should be 85%, but it's formatted as 0.85075861677733. The expression I'm using is:

=Num(Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)),'$###0') / 14100000 & ' Booked + Not Booked Towards 100% of Goal'

Does anyone have any ideas? I suspect I'm missing something simple. As always, thanks in advance for any and all help and responses.

Re: Help With Text In Chart Expression Formatting Percentage

sunny_talwar — Mon, 05 Mar 2018 18:21:12 GMT

May be this

=Num(Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0))/14100000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

Re: Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:27:56 GMT

Hello Sunny:

Thanks for the response. I tried the expression and it returns 2.4e+08% instead of 85%.

Re: Help With Text In Chart Expression Formatting Percentage

sunny_talwar — Mon, 05 Mar 2018 18:29:29 GMT

How about this

=Num((Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)))/14100000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

Re: Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:32:06 GMT

That returns 0% instead of 85%.

Re: Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:37:16 GMT

Hold on. I think I fat fingered it. My apologies.

Re: Help With Text In Chart Expression Formatting Percentage

sunny_talwar — Mon, 05 Mar 2018 18:37:32 GMT

One last try... may be this

=Num((Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)))/141000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

Re: Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:38:45 GMT

I did fat finger it. Again, my apologies. I used a fake CIO name and forgot to change it to the correct one. You're second solution works perfectly!!!!! Thank you very much. I appreciate it. I will mark the answer as correct.

Re: Help With Text In Chart Expression Formatting Percentage

pnn44794 — Mon, 05 Mar 2018 18:41:43 GMT

You’re second solution got it. It was my fault. I forgot to change the CIO name to a valid name. My apologies. I appreciate the help.