topic Re: Formating numbers in QlikView https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110156#M367224 <HTML><HEAD></HEAD><BODY><P>Good shout Antonio it should be chr(39)</P></BODY></HTML> Wed, 20 Jul 2016 16:11:18 GMT Anonymous 2016-07-20T16:11:18Z Formating numbers https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110153#M367221 <HTML><HEAD></HEAD><BODY><P>Greetings.</P><P>I need help.</P><P>How can I format a number like num(value,'##0') but with the thousand separator being the character '.</P><P>The ideia is to have numbers like 23'456.</P><P></P><P>Best regards</P><P>Simão Ribeiro </P></BODY></HTML> Wed, 20 Jul 2016 15:53:35 GMT https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110153#M367221 slribeiro 2016-07-20T15:53:35Z Re: Formating numbers https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110154#M367222 <HTML><HEAD></HEAD><BODY><P>How about something like this using ascii character 145</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">('23456',2),'##')&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(145)&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">right</SPAN><SPAN style="font-size: 8pt;">('23456',3),'##0') </SPAN></P></BODY></HTML> Wed, 20 Jul 2016 16:07:20 GMT https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110154#M367222 Anonymous 2016-07-20T16:07:20Z Re: Formating numbers https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110155#M367223 <HTML><HEAD></HEAD><BODY><P>Try</P><P><SPAN style="color: #0000ff; font-size: 10pt;">Replace</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">Num</SPAN>('23456','#.##0'),'.',<SPAN style="color: #0000ff;">Chr</SPAN></SPAN><SPAN style="font-size: 10pt;">(39)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">23456 is Your field.</SPAN></P><P></P><P></P></BODY></HTML> Wed, 20 Jul 2016 16:08:38 GMT https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110155#M367223 antoniotiman 2016-07-20T16:08:38Z Re: Formating numbers https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110156#M367224 <HTML><HEAD></HEAD><BODY><P>Good shout Antonio it should be chr(39)</P></BODY></HTML> Wed, 20 Jul 2016 16:11:18 GMT https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110156#M367224 Anonymous 2016-07-20T16:11:18Z Re: Formating numbers https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110157#M367225 <HTML><HEAD></HEAD><BODY><P>Many thanks.</P></BODY></HTML> Wed, 20 Jul 2016 16:39:29 GMT https://community.qlik.com/t5/QlikView/Formating-numbers/m-p/1110157#M367225 slribeiro 2016-07-20T16:39:29Z