topic Number Format in QlikView https://community.qlik.com/t5/QlikView/Number-Format/m-p/236241#M87439 <HTML><HEAD></HEAD><BODY><P>Do not allow pop-up for this expression, but create another one with a formula like = NUM(Column(1)/1000000000, '#,##0'). This one then may show up only.</P><P>Peter</P></BODY></HTML> Mon, 09 Nov 2009 22:07:31 GMT prieper 2009-11-09T22:07:31Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/236240#M87438 <HTML><HEAD></HEAD><BODY><P>hai there,</P><P>I got the sum value in billions eg: 564,786,789,231.00.....</P><P>when i created a chart diagram and tried to get the "Test on data point" i see all these 12 digits. but i would like to have only first 3 digits 564 billions.</P><P>i try to change in the number format, but i get 5647e+012</P><P>could any one help me out.</P><P>thank you</P></BODY></HTML> Mon, 09 Nov 2009 22:04:16 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/236240#M87438 2009-11-09T22:04:16Z Number Format https://community.qlik.com/t5/QlikView/Number-Format/m-p/236241#M87439 <HTML><HEAD></HEAD><BODY><P>Do not allow pop-up for this expression, but create another one with a formula like = NUM(Column(1)/1000000000, '#,##0'). This one then may show up only.</P><P>Peter</P></BODY></HTML> Mon, 09 Nov 2009 22:07:31 GMT https://community.qlik.com/t5/QlikView/Number-Format/m-p/236241#M87439 prieper 2009-11-09T22:07:31Z