topic Re: MonthEnd variable in QlikView

MonthEnd variable

abhijith28 — Wed, 25 Nov 2020 16:16:04 GMT

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.

PrashantSangle — Fri, 31 May 2019 10:22:42 GMT

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

abhijith28 — Fri, 31 May 2019 11:32:52 GMT

No, it is showing NULL.

sunny_talwar — Fri, 31 May 2019 11:48:04 GMT

May be try this

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

or this

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

PrashantSangle — Fri, 31 May 2019 12:00:03 GMT

where you writing code??

abhijith28 — Fri, 31 May 2019 12:01:55 GMT

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

abhijith28 — Fri, 31 May 2019 12:02:59 GMT

In the UI for pivot table