topic Number Format in QlikView https://community.qlik.com/t5/QlikView/Number-Format/m-p/282420#M1186396 <HTML><HEAD></HEAD><BODY><P>Hmmm,</P><P></P><P>Try Num(Value,If(Value=Floor(Value),'#,##0','#,##0.00'))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 22 Sep 2011 11:48:10 GMT Jason_Michaelides 2011-09-22T11:48:10Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/282419#M1186395 <HTML><HEAD></HEAD><BODY><P> Hello All.</P><P></P><P>I have field with 2 numbers: 1.5625 , 3</P><P></P><P>I want to display them (Straight Table atc...) like: 1.56, 3 (And <SPAN style="text-decoration: underline;">NOT</SPAN> 3.00, I try - '#,##0.##' ) </P><P></P><P>How can I do that? Which format I need?</P><P></P><P>Thks for your help - </P><P>Matan</P></BODY></HTML> Thu, 22 Sep 2011 11:42:12 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/282419#M1186395 matancha 2011-09-22T11:42:12Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/282420#M1186396 <HTML><HEAD></HEAD><BODY><P>Hmmm,</P><P></P><P>Try Num(Value,If(Value=Floor(Value),'#,##0','#,##0.00'))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 22 Sep 2011 11:48:10 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/282420#M1186396 Jason_Michaelides 2011-09-22T11:48:10Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/282421#M1186397 <HTML><HEAD></HEAD><BODY><P>Oops - missed a parenthesis:</P><P></P><P>Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))</P><P></P><P>Jason</P></BODY></HTML> Thu, 22 Sep 2011 11:49:34 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/282421#M1186397 Jason_Michaelides 2011-09-22T11:49:34Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/282422#M1186398 <HTML><HEAD></HEAD><BODY><P>Thnks Jason, </P><P>It's Work. </P><P></P><P>But Maybe there a way only with format pattern (without If)?</P></BODY></HTML> Thu, 22 Sep 2011 12:19:51 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/282422#M1186398 matancha 2011-09-22T12:19:51Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/282423#M1186399 <HTML><HEAD></HEAD><BODY><P>Not that I can think of I'm afraid.</P></BODY></HTML> Thu, 22 Sep 2011 12:29:17 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/282423#M1186399 Jason_Michaelides 2011-09-22T12:29:17Z