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

    Question about cummulation

      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?