topic HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE in QlikView https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108390#M759495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have this problem.</P><P>I extract value in a qlik's table (see the attached ex.xlsx)...notw i want calculate in a separate table:</P><OL><LI>The SUM of all QTA VALUE for each month</LI><LI>The delta (in %) of this SUM between a specific month FIXED (example GIU) and the other month</LI></OL><P></P><P>Can soomeone help me?</P><P></P><P>Thx</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT gabroteddy 2020-11-25T16:16:04Z HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108390#M759495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have this problem.</P><P>I extract value in a qlik's table (see the attached ex.xlsx)...notw i want calculate in a separate table:</P><OL><LI>The SUM of all QTA VALUE for each month</LI><LI>The delta (in %) of this SUM between a specific month FIXED (example GIU) and the other month</LI></OL><P></P><P>Can soomeone help me?</P><P></P><P>Thx</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108390#M759495 gabroteddy 2020-11-25T16:16:04Z Re: HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108391#M759496 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Please see the attachement. Is this type of delta calculating suitable for you?</P></BODY></HTML> Wed, 22 Aug 2018 09:30:58 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108391#M759496 Sergey_Shuklin 2018-08-22T09:30:58Z Re: HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108392#M759498 <HTML><HEAD></HEAD><BODY><P>Hi Sergey,</P><P>thx for the answer.</P><P>Your solution doesn't' work for the point 2.</P><P></P><OL style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><LI>The SUM of all QTA VALUE for each month</LI><LI>The delta (in %) of this SUM between a specific month FIXED (example GIU) and the other month</LI></OL><P></P><P>The expression</P><P></P><P>$(=sum({&lt;[Mese Esame] = p([Mese Esame])&gt;}Qta))</P><P>/</P><P>sum({&lt;[Mese Esame] = e([Mese Esame])&gt;}Qta)</P><P>-1</P><P></P><P>Not give me the aspected output.</P><P></P><P>Is possibile to have another example?</P><P>Thx</P></BODY></HTML> Wed, 22 Aug 2018 13:34:11 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108392#M759498 gabroteddy 2018-08-22T13:34:11Z Re: HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108393#M759500 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>So, the reasonable question will be: what is the expected output?</P><P>Beacuse, I'm fixin a gui and see the delta with other month:</P><P><IMG alt="delta_in_perc.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211552_delta_in_perc.png" style="height: auto;" /></P><P>what should be done in another way?</P></BODY></HTML> Thu, 23 Aug 2018 04:29:49 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-DELTA-BETWEEN-TWO-MEASURE/m-p/108393#M759500 Sergey_Shuklin 2018-08-23T04:29:49Z