Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try to use Month(addmonths(max(date),-1))
Month(AddMonths(Max(Date),-1))