Month before the selected one

[carolinne88]

Hello guys. I need help again.

I have the down table with the date fields and last month's variable (vMesRef).

vMesRef => PerID = {$(=Max(PerID))}

I need a variable that brings me the "MêsAno" before the selected one. I tried the variable "vMesRefAnt", but it does not work.

vMesRefAnt => PerID = {$(=Max(PerID)-1)}

Can someone help me?

[carolinne88 · Accepted solution]

Hello guys!

After some time and countless attempts, I discovered together with a colleague something that may have prevented the expression from working.

In the variable description field I had commented another expression and when I deleted the comment, it worked!

I believe that is the explanation, but there are some mysteries of qlik that I never discover.

Thank you all!