Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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