Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

=Month(Max(Date))-1 not working

Hi Experts,

Can any one please help me on below requirement.

I have taken

=Month(Max(Date)) then getting Jun as Max Month

but when I have taken

=Month(Max(Date))-1 then getting 5 instead of May.


Please help me how to get May for =Month(Max(Date))-1 instead of number 5


Thanks in advance.

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: =Month(Max(Date))-1 not working

let's try as below:

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

3 Replies
sunilkumarqv
Valued Contributor II

Re: =Month(Max(Date))-1 not working

try below

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


=Month(Max(Date) -1 )

agigliotti
Honored Contributor II

Re: =Month(Max(Date))-1 not working

let's try as below:

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

ChennaiahNallani
Contributor III

Re: =Month(Max(Date))-1 not working

try like below

Capture.PNG

Community Browser