topic Re: Creating a Table in QlikView

Creating a Table

santhoo_san — Mon, 24 Sep 2012 12:43:35 GMT

Hi,

I have data as below:

with this data, I want to create / derive a table which should look as below:

Margin is calculated as Revenue minus Cost for a particular Center for a particular date.

Can some one help me in writing the script.

Thank you,

Santhosh

swuehl — Mon, 24 Sep 2012 12:52:56 GMT

Maybe like this?

TABLE:

LOAD Date,

Center,

Particular,

Amount

FROM

(html, codepage is 1252, embedded labels, table is @1);

TMP:

LOAD Date, Center, sum(Amount) as Revenue

Resident TABLE where Particular = 'Revenue' group by Center, Date;

Concatenate LOAD Date, Center, sum(Amount) as Cost

Resident TABLE where Particular = 'Cost' group by Center, Date;

Concatenate (TABLE)

LOAD Date, Center, sum(Revenue) - sum(Cost) as Amount, 'Margin' as Particular

Resident TMP group by Center, Date;

drop table TMP;

santhoo_san — Mon, 24 Sep 2012 13:03:40 GMT

Thank you Swuehl. It is working wonderfully.

Regards,

Santhosh