Solved: Re: Max(MonthYear) not working - Qlik Community

bhavvibudagam · ‎2018-02-22

Hi Experts,

Can any one please help me on below requirement.

I have calculated MonthYear field in the back end like below.

MonthName(Date(Date#(Date,'YYMMDD'),'DD/MM/YYYY')) as MonthName

Getting the filter correctly like below.But when I have taken Max(MonthName) getting Feb 2018 as number format.

Please help on getting actaul format like Feb 2018.

Thanks in advance.

kaushiknsolanki · ‎2018-02-22

It is because the in background Qlik Stores it as number.

You can try this two things.

1. Maxstring(MonthName)

2. Monthname(Max(MonthName))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2018-02-22

It is because the in background Qlik Stores it as number.

You can try this two things.

1. Maxstring(MonthName)

2. Monthname(Max(MonthName))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

vijetas42 · ‎2018-02-22

try MaxString(MonthName)

Yousef_Amarneh · ‎2018-02-22

I would prefer always to use the below to do such things

Year(Date)&Num(Month(Date),'00')

So the result will be 201602, 201603 ....etc.. and here you will get the maximum number since this column is integer

Yousef Amarneh

shiveshsingh · ‎2018-02-22

Try this

Monthname(Max(MonthName))

or use interpret date# to change the format as required.