Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
let's try as below:
=Month( AddMonths( Max(Date), -1 ) )
=Month(Max(Date) -1 )
try like below