Discussion board where members can get started with Qlik Sense.
I have a variable vMonthENDDATE=date(monthend(today(),0),'YYMMDD').....Which returns the current year monthend date (20161031)
I have make this variable take current year month date as default value as well as make it dynamic for other all other month and date too..
How can I make this variable work in such a way?
User have Fiscal year and Month as the selection.
May be use this:
Date(Floor(MonthEnd(MakeDate([Fiscal Year], [Month]))), 'YYMMDD')