topic Re: Calculation in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887430#M309351 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 01 Jun 2015 12:23:50 GMT sunny_talwar 2015-06-01T12:23:50Z Calculation in Pivot table https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887427#M309348 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN class="hps">I have</SPAN> <SPAN class="hps">to divide</SPAN> <SPAN class="hps">each period</SPAN> <SPAN class="hps">by the selected</SPAN>, <SPAN class="hps">in my example</SPAN>, <SPAN class="hps">I have</SPAN> <SPAN class="hps">to divide</SPAN> <SPAN class="hps">the value of</SPAN> <SPAN class="hps atn">Sep-</SPAN>14 <SPAN class="hps">for the value of</SPAN> <SPAN class="hps">14</SPAN>-Feb <SPAN class="hps">value</SPAN>, <SPAN class="hps">and so</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">other periods</SPAN>.</P><P>The slider object is used for the user to select the number of months you want to analyze from the selected month.</P><P><SPAN class="hps alt-edited">Attached</SPAN> <SPAN class="hps">example</SPAN>.</P><P></P><P>Regards.</P><P>Sandro.</P></BODY></HTML> Mon, 01 Jun 2015 12:06:27 GMT https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887427#M309348 spividori 2015-06-01T12:06:27Z Re: Calculation in Pivot table https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887428#M309349 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P><STRONG><SPAN style="color: #ff0000;">1/(</SPAN>sum({&lt;Month={"&lt;=$(=max(Month)) &gt;$(=date(addmonths(max(Month),-$(nMeses)),'MMM YY'))"}&gt;} Indec)/sum(<SPAN style="color: #ff0000;">TOTAL</SPAN>{&lt;Month={"=max(Month)"}&gt;} Indec)<SPAN style="color: #ff0000;">)</SPAN></STRONG></P><P></P><P>Output:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88037_Capture.PNG" style="height: auto;" /></P><P></P><P>Attaching your sample back for reference</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 01 Jun 2015 12:14:15 GMT https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887428#M309349 sunny_talwar 2015-06-01T12:14:15Z Re: Calculation in Pivot table https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887429#M309350 <HTML><HEAD></HEAD><BODY><P>Hi Sunny.</P><P>It is working properly. <SPAN class="hps">Thank you.</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">Regards.</SPAN></P><P><SPAN class="hps">Sandro.</SPAN></P></BODY></HTML> Mon, 01 Jun 2015 12:22:40 GMT https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887429#M309350 spividori 2015-06-01T12:22:40Z Re: Calculation in Pivot table https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887430#M309351 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 01 Jun 2015 12:23:50 GMT https://community.qlik.com/t5/QlikView/Calculation-in-Pivot-table/m-p/887430#M309351 sunny_talwar 2015-06-01T12:23:50Z