Qlik Sense Month Function

[ritvik4BI]

Hi Experts!

I have a question. I am creating a variable vMaxMonth which gives me the latest month in MMM format from the CalenderDate field.

The expression that i am writing is :$(=month(max(CalenderDate))) 

But this is not working. Kindly suggest another expression......

[Vegar]

Do you need the dollar expansion? Why can't the variable expression just be month(max(CalenderDate), 'MMM' )? 

Is CalendarDate recognised as a numeric /date? What is the output of just using max<CalendarDate)?  Does it return a value? 

How are you using the variable in the application? Is it a part of a larger expression or is it solely for presenting the name of the latest date?

[ritvik4BI]

@Vegar ,

Pardon the photo quality..but check it out. I want output as Mar without any error........

[Ksrinivasan]

hi,

variable below to get max month in format 'MMM'

create variable as below expression, Dattee= your date field

and call in dim as below

result is in Max month if 02-02-2021 it shows as FEB

ksrinivasan