1 Reply Latest reply: Mar 11, 2015 12:56 PM by Marcus Sommer RSS

    Getting the last worked day of the month

    erick sakagami



      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?