Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?