https://community.qlik.com/t5/App-Development/Calculating-variation-of-a-value-between-current-and-previous/m-p/2435723#M96995 <P>Good afternoon,<BR /><BR />I created two variables on my qlik app, one that identifies the current month, and one that identifies the previous month. Now I wish to calculate the difference in detections between each month, I was trying to use the following expression but got an error:<BR />=Sum({&lt;'$(=vCurrentYearMonth)'&gt;} Detections) - Sum({&lt;'$(=vPreviousMaxMonth)'&gt;} Detections)<BR />Any suggestions?<BR />Detections is a defined measure in my app.</P> Thu, 28 Mar 2024 17:32:29 GMT andre_bento 2024-03-28T17:32:29Z https://community.qlik.com/t5/App-Development/Calculating-variation-of-a-value-between-current-and-previous/m-p/2435723#M96995 <P>Good afternoon,<BR /><BR />I created two variables on my qlik app, one that identifies the current month, and one that identifies the previous month. Now I wish to calculate the difference in detections between each month, I was trying to use the following expression but got an error:<BR />=Sum({&lt;'$(=vCurrentYearMonth)'&gt;} Detections) - Sum({&lt;'$(=vPreviousMaxMonth)'&gt;} Detections)<BR />Any suggestions?<BR />Detections is a defined measure in my app.</P> Thu, 28 Mar 2024 17:32:29 GMT https://community.qlik.com/t5/App-Development/Calculating-variation-of-a-value-between-current-and-previous/m-p/2435723#M96995 andre_bento 2024-03-28T17:32:29Z https://community.qlik.com/t5/App-Development/Calculating-variation-of-a-value-between-current-and-previous/m-p/2435728#M96996 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/292307">@andre_bento</a>&nbsp;<BR />Also share the expression of your variables vCurrentYearMonth and vPreviousMaxMonth<BR /><BR />Regarts, Matheus</P> Thu, 28 Mar 2024 17:56:39 GMT https://community.qlik.com/t5/App-Development/Calculating-variation-of-a-value-between-current-and-previous/m-p/2435728#M96996 MatheusC 2024-03-28T17:56:39Z