topic Re: help formatting numbers in QlikView https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28217#M4671 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG>Num(FIELD, '#.##0', ',' , '.' ) as FIELD</STRONG></P></BODY></HTML> Mon, 14 May 2018 15:16:32 GMT YoussefBelloum 2018-05-14T15:16:32Z help formatting numbers https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28215#M4669 <HTML><HEAD></HEAD><BODY><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;">Hello, Qlikers!</P><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;"></P><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;">I have values in my project that eventually comes into different format from database. I can't use same format pattern for all of them because that problem. I have an example below:</P><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;"></P><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;">DB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How I need to format</P><P style="color: #222222; font-family: tahoma, sans-serif; font-size: small;"></P><DIV class="gmail_default">35545875&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35.545<P></P><P class="gmail_default">31294345&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31.294</P><P class="gmail_default">44100.7&nbsp;&nbsp;&nbsp;&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44.100</P><P class="gmail_default">43250.7&nbsp;&nbsp;&nbsp;&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43.250</P><P class="gmail_default">1328&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.328</P><P class="gmail_default">12.9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.9 </P><P></P><P>Does anyone have faced something like that?</P><P></P><P>Tks,</P></DIV></BODY></HTML> Mon, 14 May 2018 14:51:24 GMT https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28215#M4669 martinqlik 2018-05-14T14:51:24Z Re: help formatting numbers https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28216#M4670 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe try this on the script:</P><P></P><P><STRONG>Num(FIELD, '#,##0', '.' , ',' ) as FIELD</STRONG></P></BODY></HTML> Mon, 14 May 2018 15:12:11 GMT https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28216#M4670 YoussefBelloum 2018-05-14T15:12:11Z Re: help formatting numbers https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28217#M4671 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG>Num(FIELD, '#.##0', ',' , '.' ) as FIELD</STRONG></P></BODY></HTML> Mon, 14 May 2018 15:16:32 GMT https://community.qlik.com/t5/QlikView/help-formatting-numbers/m-p/28217#M4671 YoussefBelloum 2018-05-14T15:16:32Z