Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DyadyaFedor
Contributor III
Contributor III

scatter plot chart running total

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

Customers€/mmeters
Customer 12,3610
Customer 24,80360
Customer 39,83377,5
Customer 410,83447,5
Customer 511,511007,5
Customer 611,701217,5
Customer 711,731357,5
Customer 812,091917,5
Customer 912,102477,5
Customer 1012,113597,5
Customer 1112,123807,5
Customer 1212,324087,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. 

DyadyaFedor_0-1614720810324.png

DyadyaFedor_1-1614720890388.png

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?

 

3 Replies
Saravanan_Desingh

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

commQV29.PNG

DyadyaFedor
Contributor III
Contributor III
Author

Cool! 

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

DyadyaFedor_0-1614758286080.png

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

DyadyaFedor_1-1614758522040.png

Is your chart somehow linked to your pivot table?

DyadyaFedor
Contributor III
Contributor III
Author

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