4 Replies Latest reply: May 4, 2010 5:01 AM by sandeep.gill RSS

    Cumulative or month to date figures for each day of the month

    sandeep.gill

       

      I'm pretty new to Qlik view, have just started and trying to learn. I am also trying to make cumulative count to DAY(which is a dimension) of customers added in the current month.

      I have:

      DAY CustomerID

      1 2364

      1 6726

      1 4627

      2 5399

      2 4627

      3 5391

       

      I wanted to have a cumulative count till each day on the chart for current month, but it doesn't work with the date island approach or may be i didn't understand it properly.

       

      Please help.

       

      Thanks

      Sandeep