https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555198#M62897 <P>Hi,</P><P>is there a number format that it shows decimals when there are decimals and it not shows decimals when there aren't decimals?</P><P>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.</P><P>&nbsp;</P><P>Thank you</P><P>Gabriele</P> Sat, 16 Nov 2024 06:21:50 GMT gabriele_qlik 2024-11-16T06:21:50Z https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555198#M62897 <P>Hi,</P><P>is there a number format that it shows decimals when there are decimals and it not shows decimals when there aren't decimals?</P><P>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.</P><P>&nbsp;</P><P>Thank you</P><P>Gabriele</P> Sat, 16 Nov 2024 06:21:50 GMT https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555198#M62897 gabriele_qlik 2024-11-16T06:21:50Z https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555205#M62898 <P>Try it with something like: num(VALUE, '#.##0,##')</P><P>- Marcus</P> Tue, 12 Mar 2019 09:18:51 GMT https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555205#M62898 marcus_sommer 2019-03-12T09:18:51Z https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555244#M62899 <P>I try it but it doesn't work <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P>Thank You</P><P>Gabriele</P> Tue, 12 Mar 2019 12:49:01 GMT https://community.qlik.com/t5/App-Development/Number-Formatting/m-p/1555244#M62899 gabriele_qlik 2019-03-12T12:49:01Z