Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
haha, I just remembered, that you can select full accumulation in the expression tab.
Regards
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
haha, I just remembered, that you can select full accumulation in the expression tab.
Regards
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
Hi Ivan and Umang,
Thanks a ton! It worked!.