Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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

May be use this:

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

or

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