6 Replies Latest reply: Jul 29, 2016 4:10 AM by Daniel Sander RSS

    Identify last day of month with posted values

    Daniel Sander

      Dear Qlk Users,

       

      I have a very simple data model just constisting of e.g. 10 days of a month where only day 1 - 1 are filled with values. The remaining days are empty.

       

      Which statement can I use to give me the result "5" being the last day filled with values?

       

      I tried something like this ithout success:

       

      [Day]={"<=$(=max({<[Value]>} [Day]))"}

       

      And this is the data I am talking about:

       

      DayValue

      1

      100
      2150
      330
      420
      580
      6
      7
      8
      9
      10