Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

Highlighted
Contributor II
Contributor II

I try it but it doesn't work 😞

 

Thank You

Gabriele