Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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!
Working Thanks !
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.