Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
try MaxString(MonthName)
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
Try this
Monthname(Max(MonthName))
or use interpret date# to change the format as required.