Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
junasharma
Contributor

How can we make variable Dynamic?

Hi Everyone,

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.

Thanks

Juna

1 Reply
Highlighted

Re: How can we make variable Dynamic?

May be use this:

Date(Floor(MonthEnd(Max(DateField))), 'YYMMDD')

or

Date(Floor(MonthEnd(MakeDate([Fiscal Year], [Month]))), 'YYMMDD')