Cumulative Sum with 2 dimensions

[AmelieF]

Hey, 

I have a table with customers orders by month.

Customers	Month	Orders
C1	1	10
C2	1	54
C1	2	13
C3	1	34

I want a line chart with the cumulative numbers of orders by customer by month (Each customers is a line on the chart).

I already have a line chart with the total cumulative numbers of orders  by month with this command:

rangesum(Above(Sum(orders), 0, rowno()))

But it does not work anymore when I add the customers as a line dimension in the chart.

Any idea ?

Thanks

[Oleg_Troyansky · Accepted solution]

The easiest solution would be to use a Modifier "Accumulation" on the Measure - have you tried that?

Join us at the Masters Summit for Qlik in Orlando or in Dublin to learn advanced Set Analysis, scripting, data modeling, performance, visualizations, and more - delivered by some of the best Qlik experts in the world!

[AmelieF]

Working Thanks !

[trent76]

This looks like a homework problem, so I'm going to give some more general guidance.

Try dragging Zipcode, Make, Color and # Registrations into your view. Experiment with the layout by moving pills around the view. Try using sort or filter to identify the most popular Make.