Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

New Contributor II

Getting the last worked day of the month


First of all if there's something wrong with this thread I'm sorry and can delete this, just initiating on QlikView world.

In a graphic that I update everyday worked, there is this expression

Only({<DATA={">=$(=Date(Weekstart(Today())))"} [Quantity])

where it show the progress along the week like this:

But I want to put a position of the last day of the past month, in this case it was 27 Feb (did not updated 28, so sometimes it's not the very last day of the past month that I need).

Can someone help?

Tags (4)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Getting the last worked day of the month

I suggest to solve this with flags within a master-calendar - perhaps with a if-loop over some peek()-qeries but maybe there are also more elegant solutions as that.

The Master Calendar

- Marcus