topic Re: Change value format in QlikView https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929124#M982230 <HTML><HEAD></HEAD><BODY><P>Perfect ! thank you</P><P></P><P>Stanley</P></BODY></HTML> Fri, 14 Aug 2015 21:14:49 GMT 2015-08-14T21:14:49Z Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929117#M982223 <HTML><HEAD></HEAD><BODY><P>How can I change value format 7270 to 7 270 and $17950390,380 to $17 950 390,380</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96141_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thx in advance</P></BODY></HTML> Fri, 14 Aug 2015 20:13:03 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929117#M982223 2015-08-14T20:13:03Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929118#M982224 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P>= Num( Sum(ListPriceProduct)*OrderQty, '# ###,#',',',' ')</P></BODY></HTML> Fri, 14 Aug 2015 20:16:55 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929118#M982224 swuehl 2015-08-14T20:16:55Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929119#M982225 <HTML><HEAD></HEAD><BODY><P>‌use blank as additional thousands separator parameter in the num function.</P></BODY></HTML> Fri, 14 Aug 2015 20:18:43 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929119#M982225 MarcoWedel 2015-08-14T20:18:43Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929120#M982226 <HTML><HEAD></HEAD><BODY><P>Thx but it does not work</P></BODY></HTML> Fri, 14 Aug 2015 20:46:54 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929120#M982226 2015-08-14T20:46:54Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929121#M982227 <HTML><HEAD></HEAD><BODY><P>Hm, what do you mean with 'does not work'?</P><P>No result shown at all, wrong format or...?</P><P>Above works for me, e.g. in a text box, you might need to adapt the decimal place formatting, but thousand separator works as requested.</P></BODY></HTML> Fri, 14 Aug 2015 20:55:20 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929121#M982227 swuehl 2015-08-14T20:55:20Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929122#M982228 <HTML><HEAD></HEAD><BODY><P>The result is blank</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96142_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 14 Aug 2015 20:59:23 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929122#M982228 2015-08-14T20:59:23Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929123#M982229 <HTML><HEAD></HEAD><BODY><P>Ah, ok, you copied my expression and a have a typo in the bracketing.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= Num( Sum([ListPriceProduct]*OrderQty), '# ###,###',',',' ')</SPAN></P></BODY></HTML> Fri, 14 Aug 2015 21:11:24 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929123#M982229 swuehl 2015-08-14T21:11:24Z Re: Change value format https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929124#M982230 <HTML><HEAD></HEAD><BODY><P>Perfect ! thank you</P><P></P><P>Stanley</P></BODY></HTML> Fri, 14 Aug 2015 21:14:49 GMT https://community.qlik.com/t5/QlikView/Change-value-format/m-p/929124#M982230 2015-08-14T21:14:49Z