Build a supply curve

[#1]

Good day,

While doing my coursework, I've faced a problem with building an aggregate supply curve of different companies. I have several companies with their prices and volumes. I need to sum each volume to build a supply curve. Is there a way to do it in QlikView?

Here is an example of 2 companies, but it could much more of them. Also, I attached an Excel file to understand what supply curve is.

[#2]

Also, I have a problem with data import. I import an input Excel file with multi header feature, transform it with multi_header_pivot_import.qvw script. When I try to create an aggregated table, it doesn't work for me. You can look at the samples below.

[MarcoWedel]

try switching your chart type from "straight table" to "line chart".

[MarcoWedel]

please open another thread for your multi header row excel import issue and close this one after achieving a line chart with your initial data.

thanks

regards

Marco

[#5]

MarcoWedel‌, I mean not the import issue, but a problem with straight table building. I've successfully uploaded a cross-header chart, but cannot build a table. Can you look at my Aggr.qvw sample?