topic Re: Num expression as integer when integer, else 1 decimal place in QlikView https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294882#M404338 <HTML><HEAD></HEAD><BODY><P>Even Integer means, Do you have any different Types. Would you provide sample data and expected result?</P></BODY></HTML> Thu, 18 May 2017 15:14:37 GMT Anil_Babu_Samineni 2017-05-18T15:14:37Z Num expression as integer when integer, else 1 decimal place https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294881#M404337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying express a mix of different numbers as either an integer or to 1 decimal place.</P><P></P><P>Is there anything I can do just in the Num expression that would achieve this?</P><P></P><P></P><P>Num(Sum(Number), '#,##0.0') places everything at 1 decimal place, even integers.</P><P></P><P>Thanks for the help.</P></BODY></HTML> Thu, 18 May 2017 15:08:02 GMT https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294881#M404337 pauluk__ 2017-05-18T15:08:02Z Re: Num expression as integer when integer, else 1 decimal place https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294882#M404338 <HTML><HEAD></HEAD><BODY><P>Even Integer means, Do you have any different Types. Would you provide sample data and expected result?</P></BODY></HTML> Thu, 18 May 2017 15:14:37 GMT https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294882#M404338 Anil_Babu_Samineni 2017-05-18T15:14:37Z Re: Num expression as integer when integer, else 1 decimal place https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294883#M404339 <HTML><HEAD></HEAD><BODY><P>You may try conditional statement like:</P><P></P><P><EM>=If(floor(Variable1)=Variable1, Variable1, Num(Variable1,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">#,##0.0</SPAN>'))</EM></P><P></P><P>Now replace <EM>Variable1</EM> with your expression.</P></BODY></HTML> Thu, 18 May 2017 15:21:46 GMT https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294883#M404339 tresB 2017-05-18T15:21:46Z Re: Num expression as integer when integer, else 1 decimal place https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294884#M404340 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes that is a good way of checking this thanks. I was looking more to see if it was possible in the Num expression formatting?</P></BODY></HTML> Thu, 18 May 2017 15:37:39 GMT https://community.qlik.com/t5/QlikView/Num-expression-as-integer-when-integer-else-1-decimal-place/m-p/1294884#M404340 pauluk__ 2017-05-18T15:37:39Z