topic Re: Calculate Percentage in load script in QlikView https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327554#M410531 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I understood you correctly, maybe like this?</P><P></P><P><STRONG>LOAD </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ITEM_NUMBER, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; GROSS_SALES, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; fabs( ALLOWANCES) as ALLOWANCES,</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">(ALLOWANCES/</SPAN><STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">GROSS_SALES)*100 as </SPAN><SPAN style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Percentage</SPAN></STRONG></STRONG></STRONG></P><P></P><P><STRONG>FROM</STRONG></P><P><STRONG><C></C></STRONG></P><P><STRONG>(txt, utf8, embedded labels, delimiter is ',', msq);</STRONG></P></BODY></HTML> Tue, 01 Aug 2017 10:59:21 GMT ahaahaaha 2017-08-01T10:59:21Z Calculate Percentage in load script https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327553#M410530 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>How to Calculate Percentage in load script, We give allowance to customers on top of gross sales, I have $ amounts given on CSV for allowance how to calculate <SPAN style="font-size: 13.3333px;">allowance</SPAN>% from it, in load script itself?</P><P></P><P>Attached Sample</P><P></P><P>Thanks,</P><P>D</P></BODY></HTML> Tue, 01 Aug 2017 10:35:07 GMT https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327553#M410530 dseelam 2017-08-01T10:35:07Z Re: Calculate Percentage in load script https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327554#M410531 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I understood you correctly, maybe like this?</P><P></P><P><STRONG>LOAD </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ITEM_NUMBER, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; GROSS_SALES, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; fabs( ALLOWANCES) as ALLOWANCES,</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">(ALLOWANCES/</SPAN><STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">GROSS_SALES)*100 as </SPAN><SPAN style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Percentage</SPAN></STRONG></STRONG></STRONG></P><P></P><P><STRONG>FROM</STRONG></P><P><STRONG><C></C></STRONG></P><P><STRONG>(txt, utf8, embedded labels, delimiter is ',', msq);</STRONG></P></BODY></HTML> Tue, 01 Aug 2017 10:59:21 GMT https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327554#M410531 ahaahaaha 2017-08-01T10:59:21Z Re: Calculate Percentage in load script https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327555#M410532 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>fabs(ALLOWANCES)/GROSS_SALES as [ALLOWANCE %]</STRONG></P></BODY></HTML> Tue, 01 Aug 2017 11:04:33 GMT https://community.qlik.com/t5/QlikView/Calculate-Percentage-in-load-script/m-p/1327555#M410532 sunny_talwar 2017-08-01T11:04:33Z