Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
junasharma
Not applicable

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
sunny_talwar
Not applicable

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')