Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
CuriousGeorge
Contributor II
Contributor II

Dependency on prior month calculated metric

Hi, 

I have a question, and this is a relatively easy calculation on Excel. However, my methods do not work on Qlik Sense and hope to get some ideas on this forum. To make it easier to understand, I have simplified the question and metrics.

So I have a pivot table displaying monthly snapshot (columns) and calculated metrics on each row. I need to calculate ARR for each month, and each month is dependent on the prior month metric + some current month metrics. 

I think I need to use some recursive methods, or whatever method that is the best way to calculate ARR metric. 

 

Capture.PNG

 

 

Labels (1)
0 Replies