Getting the last worked day of the month

[Anonymous]

Hello,

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?

[marcus_sommer]

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