Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing the number format (example from QV Tutorial)

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.

Changing the number format.jpg

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

Sales by A.jpg

If I am trying to change expresion definition in properties:

Chart Properties.jpg

I end up with the result showed below:

Last Pic Sales.jpg

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

3 Replies
sunny_talwar

Try wrapping your expression with Num()

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

Not applicable
Author

Thanks, but result still the same.

Num.PNG

sunny_talwar

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