topic Re: Qlik Sense Month Function in App Development

Qlik Sense Month Function

ritvik4BI — Fri, 05 Feb 2021 22:56:53 GMT

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 — Sat, 06 Feb 2021 00:56:53 GMT

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 — Sat, 06 Feb 2021 19:13:27 GMT

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

Ksrinivasan — Sun, 07 Feb 2021 13:46:18 GMT

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