Doubt about a simple trigger

[#1]

Hi everybody

I need to create a simple trigger and i don't know why it isn't working

I have 'Date' And the field 'MONTH'

I need when i open qlikview to see the month - 1 selected (if i'm in the month 03, i need to have the month 02 selected)

To see the actual month i was using  VARIABLE: MONTH // =RIGHT(MAX(Date)) And it was working

But if i try the same like this RIGHT(MAX(Date)) -1 It doesn't work

Do you know why?

Thank you

Regards

[#2]

Hi,

try to use Month(addmonths(max(date),-1))

[MK_QSL]

Month(AddMonths(Max(Date),-1))