Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhavvibudagam
Contributor II

Max(Month) not working

Hi Experts,

Can any one please help me on below issue.

I have date field like below.

I have extracted Month as

Month(CreateDate) as Month;

when I have taken Max(Month) and Max(Month)-1 on text boxes getting 12,11 instead of Dec and Nov.

I have tried

Text(Month(CreatedDate)) as Month; but still not working.

Please help me to get month in Dec format.

created date.png

Thanks in advance.

1 Solution

Accepted Solutions

Re: Max(Month) not working

May be try like this

Month(Max(Date))

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

1 Reply

Re: Max(Month) not working

May be try like this

Month(Max(Date))

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

Community Browser