18 Replies Latest reply: Sep 8, 2014 5:00 AM by Andy Weir Branched to a new discussion. RSS

    Need to report on data as at last day of the month

    Aaron Alsweiler

      Hi,

       

      I am relatively new to Qlik and so far am loving it.

       

      I have a scenario where I collect data almost daily and one of the reports that I am trying to build is giving me a headache. My specs are as follows

      Dimension = ActivityDate

      Measure = OccupUnitNo

      Trying to create a line chart that simply shows this data for the last in the calendar month that a report is submitted. This is not always the actual last day of the month as sometimes the data is not submitted due to being closed.

       

      I have taken a look around and read lots of suggestions re flags, if statements, monthend() and I cant seem to make any of them work.

       

      Would love some guidance please, thank you.