topic If number is integer, don't show decimal in QlikView https://community.qlik.com/t5/QlikView/If-number-is-integer-don-t-show-decimal/m-p/273196#M1183840 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is there any possible number format that shows the following:</P><P></P><P>- if the number is <STRONG>integer</STRONG>, don't show decimals (e.g.: 100)</P><P>- if the number is <STRONG>fractional</STRONG>, show first decimal point (e.g.: 95.5)</P><P></P><P>In other words, the format should not show the zero if it's in the decimal place.</P><P></P><P>Thank you for your help</P><P></P><P>Regards,</P><P>Julie</P></BODY></HTML> Tue, 25 Oct 2011 11:27:58 GMT 2011-10-25T11:27:58Z If number is integer, don't show decimal https://community.qlik.com/t5/QlikView/If-number-is-integer-don-t-show-decimal/m-p/273196#M1183840 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is there any possible number format that shows the following:</P><P></P><P>- if the number is <STRONG>integer</STRONG>, don't show decimals (e.g.: 100)</P><P>- if the number is <STRONG>fractional</STRONG>, show first decimal point (e.g.: 95.5)</P><P></P><P>In other words, the format should not show the zero if it's in the decimal place.</P><P></P><P>Thank you for your help</P><P></P><P>Regards,</P><P>Julie</P></BODY></HTML> Tue, 25 Oct 2011 11:27:58 GMT https://community.qlik.com/t5/QlikView/If-number-is-integer-don-t-show-decimal/m-p/273196#M1183840 2011-10-25T11:27:58Z