Solved: Re: MonthEnd variable - Qlik Community

abhijith28 · ‎2019-05-31

i have created a variable: with the date field

vMonthEnd = date(monthend(max(dates),-1))

but =if(dates=$(='vMonthEnddd'),dates) is not working in filter pane.

sunny_talwar · ‎2019-05-31

May be try this

If(dates = Floor($(vMonthEnd)), dates)

or this

If(dates = Floor(MonthEnd(Max(TOTAL dates), -1)), dates)

View solution in original post

PrashantSangle · ‎2019-05-31

try
if(dates=$(vMonthEnd),dates)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

abhijith28 · ‎2019-05-31

No, it is showing NULL.

sunny_talwar · ‎2019-05-31

May be try this

If(dates = Floor($(vMonthEnd)), dates)

or this

If(dates = Floor(MonthEnd(Max(TOTAL dates), -1)), dates)

PrashantSangle · ‎2019-05-31

where you writing code??

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

abhijith28 · ‎2019-05-31

Thank you so much:)
If(dates = Floor(MonthEnd(Max(TOTAL dates), -1)), dates) is working fine..

abhijith28 · ‎2019-05-31

In the UI for pivot table