4 Replies Latest reply: Apr 13, 2017 11:37 AM by omar bensalem RSS

    Question about cummulation

    Robert Steffensen

      Data Base contains 3 values: Creation date, Closing date, Key.

      I want to have the time on the X axis and the number of open operations on the Y axis.

       

      According to my logic:

      Open Operations = (Creation < Current X Value) - (Completed < Current X Value)

       

      My experiments look like this:

      Count ({1 <Creation <{$ <Now>}} Key)

       

      What is the formula for this? In SQL no problem, but in Qlik Sense?


      THX