topic Re: Calculating Percentage in QlikView https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9880#M1535 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>(sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eSales))</STRONG></P><P><STRONG>-sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eRent)))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG><SPAN style="color: #ff0000;">(</SPAN>sum(<SPAN style="color: #ff0000;">TOTAL</SPAN> {$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eSales))</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>-sum(<STRONG style="color: #ff0000;">TOTAL </STRONG>{$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eRent))<SPAN style="color: #ff0000;">)</SPAN></STRONG></P></BODY></HTML> Mon, 26 Feb 2018 13:15:49 GMT sunny_talwar 2018-02-26T13:15:49Z Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9879#M1534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want&nbsp; to calculate percentage of total sales per customer/total sales for dates which are selected.</P><P>Am using the formula</P><P></P><P><SPAN style="font-size: 8pt;">(sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eSales))</SPAN></P><P><SPAN style="font-size: 8pt;">-sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eRent)))</SPAN></P><P><SPAN style="font-size: 8pt;">/</SPAN></P><P><SPAN style="font-size: 8pt;">sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eSales))</SPAN></P><P><SPAN style="font-size: 8pt;">-sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eRent))</SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">But the result is 100%.</SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG alt="cont.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194522_cont.png" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">Thanks,</SPAN></P><P><SPAN style="font-size: 8pt;">Remya<BR /></SPAN></P></BODY></HTML> Mon, 26 Feb 2018 07:37:11 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9879#M1534 Anonymous 2018-02-26T07:37:11Z Re: Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9880#M1535 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>(sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eSales))</STRONG></P><P><STRONG>-sum({$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode&gt;} $(eRent)))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG><SPAN style="color: #ff0000;">(</SPAN>sum(<SPAN style="color: #ff0000;">TOTAL</SPAN> {$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eSales))</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>-sum(<STRONG style="color: #ff0000;">TOTAL </STRONG>{$&lt;DateKey={"&gt;=$(=Date(vFromDate,'YYYYMMDD'))&lt;=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=&gt;} $(eRent))<SPAN style="color: #ff0000;">)</SPAN></STRONG></P></BODY></HTML> Mon, 26 Feb 2018 13:15:49 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9880#M1535 sunny_talwar 2018-02-26T13:15:49Z Re: Calculating Percentage https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9881#M1536 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Mon, 26 Feb 2018 13:34:25 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage/m-p/9881#M1536 Anonymous 2018-02-26T13:34:25Z