topic Re: Subfield Question ? in QlikView https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630414#M231360 <HTML><HEAD></HEAD><BODY><P>Thank you at all.In fact I have a list with following values</P><P>1000</P><P>2000</P><P>10000</P><P>20000</P><P>100000</P><P>200000</P><P>1100000<BR />and I want a dynamic format like :</P><P>1,000</P><P>2,000</P><P>10,000</P><P>20,000</P><P>100,000</P><P>200,000</P><P>1 100,000</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 13 May 2014 05:49:07 GMT suzel404 2014-05-13T05:49:07Z Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630408#M231354 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I transform the number 1100000 to 1 100,000 ?</P><P>left(Field,len(Field)-3)&amp;','&amp;right(Field,3))) give me 1100,000</P><P></P><P>Thank for your help.</P></BODY></HTML> Mon, 12 May 2014 23:00:05 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630408#M231354 suzel404 2014-05-12T23:00:05Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630409#M231355 <HTML><HEAD></HEAD><BODY><P>=replace(replace(num(1100000 ,'#,##0.00'),',',' '),'.',',')</P></BODY></HTML> Mon, 12 May 2014 23:21:05 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630409#M231355 Clever_Anjos 2014-05-12T23:21:05Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630410#M231356 <HTML><HEAD></HEAD><BODY><P><BR />Hi Clever,</P><P></P><P>Thank for your response but your expression gives 1100000 000,00. I want to obtain 1 100,000.</P></BODY></HTML> Mon, 12 May 2014 23:44:35 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630410#M231356 suzel404 2014-05-12T23:44:35Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630411#M231357 <HTML><HEAD></HEAD><BODY><P>Try this expression</P><P></P><P>=left(field,1)&amp;' '&amp;mid(field,2,3)&amp;','&amp;right(field,3)</P><P></P><P>hope it will help</P></BODY></HTML> Tue, 13 May 2014 04:49:03 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630411#M231357 2014-05-13T04:49:03Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630412#M231358 <HTML><HEAD></HEAD><BODY><P>Round(1100000/1000000) &amp; ' ' &amp; Num(Mod(1100000,1000000),'#,##0')</P></BODY></HTML> Tue, 13 May 2014 05:13:15 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630412#M231358 anbu1984 2014-05-13T05:13:15Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630413#M231359 <HTML><HEAD></HEAD><BODY><P>You can try this also</P><P></P><P>=Left(left(1100000,len(1100000)-3)&amp;','&amp;right(1100000,3),1)&amp;'&nbsp; '&amp;Right(left(1100000,len(1100000)-3)&amp;','&amp;right(1100000,3),7)</P></BODY></HTML> Tue, 13 May 2014 05:21:09 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630413#M231359 its_anandrjs 2014-05-13T05:21:09Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630414#M231360 <HTML><HEAD></HEAD><BODY><P>Thank you at all.In fact I have a list with following values</P><P>1000</P><P>2000</P><P>10000</P><P>20000</P><P>100000</P><P>200000</P><P>1100000<BR />and I want a dynamic format like :</P><P>1,000</P><P>2,000</P><P>10,000</P><P>20,000</P><P>100,000</P><P>200,000</P><P>1 100,000</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 13 May 2014 05:49:07 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630414#M231360 suzel404 2014-05-13T05:49:07Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630415#M231361 <HTML><HEAD></HEAD><BODY><P>Load If(Round(Num/1000000)&gt; 0, Round(Num/1000000) &amp; ' ','') &amp; Num(Mod(Num,1000000),'#,##0') Inline [</P><P>Num</P><P>1000</P><P>2000</P><P>10000</P><P>20000</P><P>100000</P><P>200000</P><P>1100000 ];</P></BODY></HTML> Tue, 13 May 2014 05:52:59 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630415#M231361 anbu1984 2014-05-13T05:52:59Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630416#M231362 <HTML><HEAD></HEAD><BODY><P>What are your configurations?</P><P>SET ThousandSep='.';</P><P>SET DecimalSep=',';</P></BODY></HTML> Tue, 13 May 2014 11:40:07 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630416#M231362 Clever_Anjos 2014-05-13T11:40:07Z Re: Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630417#M231363 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 13 May 2014 11:44:40 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630417#M231363 Clever_Anjos 2014-05-13T11:44:40Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630418#M231364 <HTML><HEAD></HEAD><BODY><P><BR />Thank you Anand.</P></BODY></HTML> Tue, 13 May 2014 18:42:48 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630418#M231364 suzel404 2014-05-13T18:42:48Z Re: Subfield Question ? https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630419#M231365 <HTML><HEAD></HEAD><BODY><P>just one more:</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_14000235236127819 jive_text_macro jive_macro_code" jivemacro_uid="_14000235236127819"> <P>LOAD NumIn, Replace(Left(NumTemp, PosLastSep-1), ',', ' ')&amp;Right(NumTemp, Len(NumTemp)-PosLastSep+1) as NumOut;</P> <P>LOAD *, Index(NumTemp, ',', -1) as PosLastSep;</P> <P>LOAD *, Num(NumIn, '#,##0', '.', ',') as NumTemp</P> <P>Inline [</P> <P>NumIn</P> <P>1</P> <P>2</P> <P>10</P> <P>20</P> <P>100</P> <P>200</P> <P>1000</P> <P>2000</P> <P>10000</P> <P>20000</P> <P>100000</P> <P>200000</P> <P>1100000</P> <P>2000000</P> <P>10000000</P> <P>20000000</P> <P>100000000</P> <P>200000000</P> <P>1000000000</P> <P>2000000000</P> <P>10000000000</P> <P>20000000000</P> <P>100000000000</P> <P>200000000000</P> <P>1000000000000</P> <P>2000000000000</P> <P>];</P> </PRE><P></P><P><IMG alt="QlikCommunity_Thread_118144_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/58799_QlikCommunity_Thread_118144_Pic1.JPG.jpg" /></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 13 May 2014 23:26:32 GMT https://community.qlik.com/t5/QlikView/Subfield-Question/m-p/630419#M231365 MarcoWedel 2014-05-13T23:26:32Z