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

[#1]

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

[#2]

Hi there, is preetty easy doing cummulatives, unless I am discarding some part of your issue, you wont even need the table island approach. For instace, if you have a table with a Day dimmension, then you can cummulate your clientes with something similar to:

rangesum(above(), count(ClientID))

Regards

[#3 · Accepted solution]

haha, I just remembered, that you can select full accumulation in the expression tab.

Regards

[#4]

Hi Sandeep.,

Create a Straight table with Date as the dimension and In the expression write Sum (CustomerID) and select 'Full Accumulation" option at the bottom left

[#5]

Hi Ivan and Umang,

Thanks a ton! It worked!.