topic Find % Difference between continuous Months in App Development

Find % Difference between continuous Months

ryanlessig — Tue, 05 Jun 2018 22:15:54 GMT

Hello,

I am working in QlikSense trying have a continuous calculation comparing month to month of a value, based on the month dimension.

Here is a sample table, this table goes back 11 years.

I want to calculate what is in the % Difference vs. Last Month column, in QlikSense. The basic math is (CurrentMonth/Previous Month)-1

Here is the expression I have:

Sum({<[Euro.Month and Year.autoCalendar.Month]>}[Euro.Database Rate])/Sum({<[Euro.Month and Year.autoCalendar.Month]>-1}[Euro.Database Rate])-1

It is not returning any value. Any suggestions would be appreciated!

Thanks!

lironbaram — Wed, 06 Jun 2018 05:11:39 GMT

assuming you'll keep the months sorted in descending order

you can use this formula

Sum[Euro.Database Rate])/below(Sum([Euro.Database Rate]))-1

praveenkumar_ma — Wed, 06 Jun 2018 09:32:13 GMT

may be Helpful

Sum[Euro.Database Rate])/Before(Sum([Euro.Database Rate]))-1...

Regards

sunny_talwar — Wed, 06 Jun 2018 11:39:13 GMT

Or this if you would be making selection in 'Euro.Month and Year' field

Sum[Euro.Database Rate])/Below(Sum({<[Euro.Month and Year]>}[Euro.Database Rate]))-1