topic Max(MonthYear) not working in QlikView

Max(MonthYear) not working

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 22 Feb 2018 07:11:14 GMT

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

vijetas42 — Thu, 22 Feb 2018 07:17:55 GMT

try MaxString(MonthName)

Yousef_Amarneh — Thu, 22 Feb 2018 07:29:44 GMT

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

shiveshsingh — Thu, 22 Feb 2018 08:06:24 GMT

Try this

Monthname(Max(MonthName))

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