Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele_qlik
Contributor III
Contributor III

Number Formatting

Hi,

is there a number format that it shows decimals when there are decimals and it not shows decimals when there aren't decimals?

For example, if I have 2000 I want to show 2.000 and not 2.000,00 but if I have 2000,55 I want to show 2.000,55 and not 2.000.

 

Thank you

Gabriele

2 Replies
marcus_sommer

Try it with something like: num(VALUE, '#.##0,##')

- Marcus

gabriele_qlik
Contributor III
Contributor III
Author

I try it but it doesn't work 😞

 

Thank You

Gabriele