https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695701#M53201 <P>Try this:</P><P>Sum({&lt;YearMonth = {'$(=vMaxYearMonth)'}&gt;}TOT_Maara) -<BR />Sum({&lt;YearMonth = {'$(=vPrevYearMonth)'}&gt;}TOT_Maara)</P> Wed, 22 Apr 2020 11:28:25 GMT BalaBhaskar_Qlik 2020-04-22T11:28:25Z https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695509#M53179 <P>Hey,</P><P>My goal is to have period quantity figures when I already have the cumulative ones.</P><P>I have set the&nbsp;following variables</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Variables" style="width: 226px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32247i6D6040F57D1C0A72/image-size/large?v=v2&amp;px=999" role="button" title="Variables.png" alt="Variables" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Variables</span></span></P><P>The formula that I used in expression:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Expression" style="width: 448px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32249i204CEF6277A9C07D/image-size/large?v=v2&amp;px=999" role="button" title="Expression_.png" alt="Expression" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Expression</span></span>'</P><P>The end result you will find below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Result" style="width: 554px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32250i4CDC6704222D038F/image-size/large?v=v2&amp;px=999" role="button" title="Result.png" alt="Result" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Result</span></span></P><P>Period quantity expession is not working as I wanted to. Cumulative quantity expression (=sum(TOT_Määrä)&nbsp;work just fine.</P><P>Could you guys help me with this problem?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P> Wed, 22 Apr 2020 03:59:14 GMT https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695509#M53179 JMA_1 2020-04-22T03:59:14Z https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695701#M53201 <P>Try this:</P><P>Sum({&lt;YearMonth = {'$(=vMaxYearMonth)'}&gt;}TOT_Maara) -<BR />Sum({&lt;YearMonth = {'$(=vPrevYearMonth)'}&gt;}TOT_Maara)</P> Wed, 22 Apr 2020 11:28:25 GMT https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695701#M53201 BalaBhaskar_Qlik 2020-04-22T11:28:25Z https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695735#M53208 <P>Thank you for your response but it didn't sovle the problem.</P> Wed, 22 Apr 2020 12:47:51 GMT https://community.qlik.com/t5/App-Development/Problems-with-set-expression-vMaxYearMonth-vPreviousMonth-period/m-p/1695735#M53208 JMA_1 2020-04-22T12:47:51Z