Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_bento
Contributor II
Contributor II

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
Specialist

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!