topic Re: Changing the number format (example from QV Tutorial) in QlikView

Changing the number format (example from QV Tutorial)

Wed, 03 Feb 2016 07:16:39 GMT

Hi all,

I was reading QV tutorial.pdf lately. In page 64, there is "Changing the number format" section. My goal is to replicate what is shown in the tutorial - shorten numbers in data labels above bars and 1,000 $ value at the top of Y-axis.

While I am trying to do what is told by instructions, I end up with the result showed below:

If I am trying to change expresion definition in properties:

I end up with the result showed below:

This means that I cannot show 1,000 % value at the top of Y-axis.

Do you have any suggestions how to solve this?

Thanks a lot Qlik Community!

Audrius

Re: Changing the number format (example from QV Tutorial)

sunny_talwar — Wed, 03 Feb 2016 17:15:30 GMT

Try wrapping your expression with Num()

=Num(Sum(Sales), '#,##0%')

Re: Changing the number format (example from QV Tutorial)

Thu, 04 Feb 2016 09:40:36 GMT

Thanks, but result still the same.

Re: Changing the number format (example from QV Tutorial)

sunny_talwar — Thu, 04 Feb 2016 17:28:25 GMT

Have you also selected 'Expression Default' from Number tab of the properties?