Doubt about a simple trigger

Thu, 12 Mar 2015 18:44:08 GMT

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

Re: Doubt about a simple trigger

Thu, 12 Mar 2015 19:05:06 GMT

Hi,

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

MK_QSL — Thu, 12 Mar 2015 19:28:19 GMT

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