https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930300#M1218939 <P>Hello All,</P> <P>I am trying to get ride of extra decimals at script level itself ,which I havent succeeded</P> <P>Any suggestion will be very helpful&nbsp;</P> <P>Sample Data set&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Price,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sale,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;586.065434563&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23876.2310098712&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98765.045629434545</P> <P>Out put Excepting&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sale,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;586&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23876.231&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 98765.045629</P> <P>&nbsp;</P> <P>Like&nbsp; &nbsp; &nbsp; Price column should have 0 decimals&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales Column should&nbsp; need to have only 3 decimals&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount Column Should need to have 6 decimals&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>How can I able to&nbsp; achieve this requirement ?</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank You&nbsp;</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 13 May 2022 09:49:06 GMT kunkumnaveen 2022-05-13T09:49:06Z https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930300#M1218939 <P>Hello All,</P> <P>I am trying to get ride of extra decimals at script level itself ,which I havent succeeded</P> <P>Any suggestion will be very helpful&nbsp;</P> <P>Sample Data set&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Price,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sale,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;586.065434563&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23876.2310098712&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98765.045629434545</P> <P>Out put Excepting&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sale,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;586&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23876.231&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 98765.045629</P> <P>&nbsp;</P> <P>Like&nbsp; &nbsp; &nbsp; Price column should have 0 decimals&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales Column should&nbsp; need to have only 3 decimals&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount Column Should need to have 6 decimals&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>How can I able to&nbsp; achieve this requirement ?</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank You&nbsp;</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 13 May 2022 09:49:06 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930300#M1218939 kunkumnaveen 2022-05-13T09:49:06Z https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930310#M1218940 <P>Hi</P> <P>Try like below</P> <P>Load Num(Price, '#,##0') as Price, Num(Sale, '#,##0.###') as Sale,Num(Amount, '#,##0.######') as Amount Inline<BR />[<BR />Price, Sale, Amount</P> <P>586.065434563, 23876.2310098712, 98765.045629434545<BR />];</P> <P>O/p:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1652435896560.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/79352iF006FF0CA8B57496/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1652435896560.png" alt="MayilVahanan_0-1652435896560.png" /></span></P> <P>&nbsp;</P> Fri, 13 May 2022 09:58:22 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930310#M1218940 MayilVahanan 2022-05-13T09:58:22Z https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930318#M1218942 <P>Thanks Mayil for the quick reply</P> <P>I tried <STRONG>Num</STRONG> but it is not working in my case , can we use round if so how to get decimals in round function&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Num1.PNG" style="width: 166px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/79353i147D024DCB9F3F52/image-size/medium?v=v2&amp;px=400" role="button" title="Num1.PNG" alt="Num1.PNG" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Num2.PNG" style="width: 323px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/79354i732007B18DC93C2F/image-size/medium?v=v2&amp;px=400" role="button" title="Num2.PNG" alt="Num2.PNG" /></span></P> <P>&nbsp;</P> Fri, 13 May 2022 10:09:49 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-the-requirement-at-script-level/m-p/1930318#M1218942 kunkumnaveen 2022-05-13T10:09:49Z