Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agusmroldan
New Contributor

Calculate Field Value Previous Month

Hello! I'm trying to calculate a field value for the previous month in a new column of the same table but I'm not able...

My table looks like this:

Captura.PNG

The field TOTAL_EUROS_MES_ANTERIOR should be the value of the total amount of sales in the previous month. For example, for year 2017, period 10 it should value 42443

Thanks a lot for your help.
Regards

3 Replies
MVP
MVP

Re: Calculate Field Value Previous Month

Doing this in the script or front end?

agusmroldan
New Contributor

Re: Calculate Field Value Previous Month

I'm trying to solve it in the front end, in Set Analysis.

MVP
MVP

Re: Calculate Field Value Previous Month

You will need Above/Below to do this. Check here

Missing Manual - Above() and Below()