Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_bento
Contributor III
Contributor III

Calculating variation of a value between current and previous month

Good afternoon,

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:
=Sum({<'$(=vCurrentYearMonth)'>} Detections) - Sum({<'$(=vPreviousMaxMonth)'>} Detections)
Any suggestions?
Detections is a defined measure in my app.

Labels (1)
1 Reply
MatheusC
Specialist II
Specialist II

Hi, @andre_bento 
Also share the expression of your variables vCurrentYearMonth and vPreviousMaxMonth

Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!