topic Re: Build a supply curve. Part 2 in QlikView

Build a supply curve. Part 2

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

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 swuehl‌I'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).

Re: Build a supply curve. Part 2

swuehl — Mon, 21 Mar 2016 20:30:05 GMT

Maybe like attached, adding this to the end of your current script:


RESULT:
NoConcatenate
LOAD Company,
  Price,
  Day,
  ColNo,
  RangeSum(Amount,If(Previous(ColNo)=ColNo,-Previous(Amount))) as Amount
Resident ResultTable
Order By ColNo, Day; 

Concatenate (RESULT)
LOAD 'Aggregated' as Company,
  Price,
  ColNo,
  Day,
  Amount
Resident RESULT;

DROP TABLE ResultTable;

Re: Build a supply curve. Part 2

MarcoWedel — Tue, 22 Mar 2016 00:23:29 GMT

Hi,

what is your expected result for this data?

regards

Marco

Re: Build a supply curve. Part 2

Tue, 22 Mar 2016 02:42:34 GMT

@ 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.

Re: Build a supply curve. Part 2

Tue, 22 Mar 2016 06:33:45 GMT

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).

Re: Build a supply curve. Part 2

Tue, 22 Mar 2016 18:39:52 GMT

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.

Re: Build a supply curve. Part 2

swuehl — Tue, 22 Mar 2016 18:42:28 GMT

Rockrocker, you can set a straight table to 'horizontal' layout on presentation tab of chart properties.

Re: Build a supply curve. Part 2

Wed, 23 Mar 2016 10:47:40 GMT

BUMP. Hope that somebody can help me.