topic Re: summerise table in QlikView

summerise table

Thu, 28 Mar 2013 13:41:08 GMT

I have this table

and in the first column is the Key, which repeats 3times (because of 3 concatenated tables). In the other columns there is just one value for the keys.

Now I want to summerise this table to 1 row, with all the values in the columns

My script looks like this

Table:

load Key,

Column1,

Column2

resident Temp;

What do I have to add to Summerise the table? I tried group by but I get error messages

Thanks a lot in advanced

Thomas

Re: summerise table

Thu, 28 Mar 2013 14:14:08 GMT

Table:

load Key,

sum(Column1),

sum(Column2)

resident Table_temp

GRUP BY Key;

(DROP TABLE Table_temp// if you don't need anymore)

Re: summerise table

Thu, 28 Mar 2013 14:37:44 GMT

Thanks a lot, this is perfectly working