topic Re: scatter plot chart running total in App Development

scatter plot chart running total

DyadyaFedor — Tue, 02 Mar 2021 21:37:15 GMT

On a sheet in my app, I made a pivot table that looks like this

Customers	€/m	meters
Customer 1	2,36	10
Customer 2	4,80	360
Customer 3	9,83	377,5
Customer 4	10,83	447,5
Customer 5	11,51	1007,5
Customer 6	11,70	1217,5
Customer 7	11,73	1357,5
Customer 8	12,09	1917,5
Customer 9	12,10	2477,5
Customer 10	12,11	3597,5
Customer 11	12,12	3807,5
Customer 12	12,32	4087,5

I sorted first column ascending by €/m, and used this formula =Rangesum(Above(TOTAL Sum([Corporate quantity 2]),0,rowno(TOTAL))) to get running total in third column.

I'd like to replace the pivot table with a chart.

Customers would be a dimension, X-axis would be €/m, Y-axis would be running total. I am trying to use the same formula for runnig total, but how do I sort customers ascending inside the chart?

Re: scatter plot chart running total

Saravanan_Desingh — Wed, 03 Mar 2021 02:43:58 GMT

I am able to create this in QlikView. Please let me know issue you are facing.

Re: scatter plot chart running total

DyadyaFedor — Wed, 03 Mar 2021 08:03:18 GMT

Cool!

my sheet looks like this. I have several filters. The customers in the table depend on the filters of course.

and my scatter chart looks likes this, because the customers inside the chart are not sorted ascending by €/m.

Is your chart somehow linked to your pivot table?

Re: scatter plot chart running total

DyadyaFedor — Wed, 03 Mar 2021 08:24:25 GMT

Solved! I simply drag and dropped scatter plot over pivot table and converted pivot table to scartter chart