7 Replies Latest reply: Aug 13, 2018 12:03 PM by Anil Samineni RSS

    Accumulation with dates

    Jukka Rahnasto

      Hi, I'm quite new to Qlik Sense and I'm trying to do cumulative graph visualizing the status of our work orders of our project.

       

      My data looks like this:

       

        

      Work order numberworks startworks end
      3761857--
      37674676.8.2018 7:50-
      37678336.8.2018 7:48-
      37678606.8.2018 7:47-
      37678726.8.2018 7:518.8.2018 13:51
      37679036.8.2018 7:20-
      376873216.4.2018 7:19-
      376899519.4.2018 13:26-
      376974330.7.2018 8:47-
      3774993--
      3779187--
      377930926.4.2018 7:0520.6.2018 7:24
      3789542--
      3789549--
      3789553--
      3789564--
      3789568--
      3789572--
      3789576--

       

      Ideally I'd like to have a combo chart, which has dates in the x-axis (from 1.8.2018 - 1.10.2018), and three measures: 1) bar for opened work orders for each day, 2) bar for closed work orders per day, 3) a cumulative line showing amount of open work orders.

       

      I have been really stuck with this for a few weeks now, any help would be highly appreciated!