topic Changing Number Format in QlikView https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246355#M582170 <HTML><HEAD></HEAD><BODY><P>Works also! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Jan 2012 09:52:33 GMT 2012-01-03T09:52:33Z Changing Number Format https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246351#M582166 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I would like to change the number format of a Column in a Chart Straight Table. I select the column under dimensions because I have to suppress it when the value is null. (I know its possible if I select it as an expression).</P><P></P><P>I assume I can adjust the format also of a dimension but I'm a bit confused here, I see 'Text Format' but do not know what code I should type to set it correct.&nbsp; (Needs to be money-format)</P><P></P><P>Txs</P></BODY></HTML> Tue, 03 Jan 2012 09:15:29 GMT https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246351#M582166 2012-01-03T09:15:29Z Changing Number Format https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246352#M582167 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>You can use the calculated dimension&nbsp; =Num(FieldName<SPAN style="font-size: 8pt;">,'£#,##0.00;(£#,##0.00)') </SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">VIjay</SPAN></P></BODY></HTML> Tue, 03 Jan 2012 09:27:24 GMT https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246352#M582167 vijay_iitkgp 2012-01-03T09:27:24Z Changing Number Format https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246353#M582168 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>With your dimension =MONEY(Field)</P><P></P><P>Regards,</P><P>Sokkorn Cheav</P></BODY></HTML> Tue, 03 Jan 2012 09:31:14 GMT https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246353#M582168 Sokkorn 2012-01-03T09:31:14Z Changing Number Format https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246354#M582169 <HTML><HEAD></HEAD><BODY><P>Thanks a lot for this quick response! </P><P>Helps me a great deal <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Jan 2012 09:31:37 GMT https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246354#M582169 2012-01-03T09:31:37Z Changing Number Format https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246355#M582170 <HTML><HEAD></HEAD><BODY><P>Works also! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Jan 2012 09:52:33 GMT https://community.qlik.com/t5/QlikView/Changing-Number-Format/m-p/246355#M582170 2012-01-03T09:52:33Z