topic Re: sum for several values in QlikView

sum for several values

Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to sum for several values?

I'd like to sum in an expression like this: ins + side + date = price*volume.

is that possible?

Re: sum for several values

agomes1971 — Thu, 01 Sep 2016 10:12:33 GMT

Hi,

do you mean:

'ins' & '+' & 'side' & '+' & 'date' = price*volume ?

HTH

André Gomes

Re: sum for several values

Thu, 01 Sep 2016 10:15:22 GMT

not addition sorry, but when they match make a row instead of having 10 rows. Aggregate them so to speak...

Re: sum for several values

Chanty4u — Thu, 01 Sep 2016 10:16:31 GMT

is this?

TEST1:

LOAD * INLINE [

id, description

1, AB20

2, BA20

3, 20-11-16 20 pounds

4, 24-12-2015 15 pounds

5, 13 pounds

] ;

Result:

LOAD *

sum(id)+ sum(id) as [Price*value]

Resident TEST1;

Re: sum for several values

Anil_Babu_Samineni — Thu, 01 Sep 2016 10:17:24 GMT

Yes, Sum (V1 + V2). But i am not getting the expression. Ccan you please elaborate more

Re: sum for several values

Thu, 01 Sep 2016 10:19:27 GMT

You mean:

LOAD * INLINE [

ins, side, date

1, 18, 19

2, 17, 19

3, 16, 19

4, 15, 19

5, 14, 19

6, 13, 19

7, 12, 19

8, 11, 19

9, 10, 19

10, 9, 19

11, 8, 19

12, 7, 19

13, 6, 19

14, 5, 19

15, 4, 19

16, 3, 19

17, 2, 19

18, 1, 19

];

SUM(ins + side + date) //would be the same as sum(38) for each line.

Re: sum for several values

Thu, 01 Sep 2016 10:23:43 GMT

So look at this picture below. They all match on Date, side and Isin. So they should be in one row. Can you make an expression to make this work?

Re: sum for several values

Chanty4u — Thu, 01 Sep 2016 10:25:43 GMT

May use try with rangesum function

RangeSum ‒ QlikView

Re: sum for several values

effinty2112 — Thu, 01 Sep 2016 10:31:05 GMT

Hi Niklas,

Take out the dimensions apart from Date, side and Isin. If you need info from other dimensions then you need to aggregate them and put in as expression.

Cheers

Andrew

Re: sum for several values

ToniKautto — Thu, 01 Sep 2016 10:33:30 GMT

Would this work?

It basically means that aggregation is grouped over date,side and ins.

Sum(TOTAL <date,side,ins> price*volume)

Re: sum for several values

Thu, 01 Sep 2016 10:49:43 GMT

I know it would be possible but they have the same info in every cell. Wonder why dont aggregate

Re: sum for several values

ToniKautto — Thu, 01 Sep 2016 21:39:22 GMT

It is really hard to give a precise answer without seeing the underlying data. Can you provide a sample on what the loaded data looks like, and what you expected straight table is expected to look like?

From you image above, are you expecting one table row instead of five?