My main aim was to find out a way to create an aggregate curve or table from 2 simple tables (Supply.xlsx). Thanks to MarcoWedel and swuehlI've managed it (Part 1 Re: Build a supply curve). However, when I tried to do the same thing with uploaded multi-header table, it didn't work. According to the Part 1, can anybody help me with the problem?
P.S. I have attached an Excel and Qlikview files (Aggr.xls and .qvw).
Maybe like attached, adding this to the end of your current script:
RangeSum(Amount,If(Previous(ColNo)=ColNo,-Previous(Amount))) as Amount
Order By ColNo, Day;
LOAD 'Aggregated' as Company,
DROP TABLE ResultTable;
@ swuehl I am new to qlikview . can you tell me how did you change the alignment of straight table Amount. in this table Amount And price column are horizontal . But by default when I do straight table it comes vertical.
MarcoWedel, in comparison with Part 1, I've added additional variable Day. All I need is the ability to build each day's aggregate table (curve) like you have shown me in Part 1. In actual practice, I have a very large dataset (similar to Aggr.xls).
swuehl, it doesn't work correctly.
1. It works only with Day 1.
2. It calculates a simple full accumulation but I need the one, which was showed in Supply.xlsx.
P.S. I've attached files. Also, I've changed Excel dataset values to make numbers more suitable for visualization.