9 Replies Latest reply: Dec 13, 2016 9:29 AM by Jose Persichini RSS

    Flag for the last day in the month

    Jose Persichini

      Hello, I am using QlikSense. I want to get the last day of every month. I read to use a flag to set the last day in the month; but this not work for me because I am not sure that the last day of the month is in my data. For example:

      DateLast day in month?
      01/01/2016No
      ......
      30/01/2016Yes
      01/02/2016No
      ......
      29/02/2016Yes

       

      January has 31 days. But the day 31 is not in my data, so I want to mark the day 30 as the last. Or the day 29, 28, etc... I want to mark the last day of the month "in my data".

       

      How can I do?

       

      Thanks!