topic Sum of rows in QlikView

Sum of rows

Mon, 07 Apr 2014 09:31:49 GMT

Hi All

I have this data:

Hi All

I have this data:

in a table.I want to set an expression to have this result:

A -> 6 (sum of all Number with Period=A)

C -> 4 (sum of all Number with Period=C)

B -> 50 (sum of all Number with Period=B)

and so on..

How can I set the sum() ? Aggr ( sum (Distinct Number), Period) doesn't work..

Thanks

luca

in a table.I want to set an expression to have this result:

A -> 6 (sum of all Number with Period=A)

C -> 4 (sum of all Number with Period=C)

B -> 50 (sum of all Number with Period=B)

and so on..

How can I set the sum() ? sum (Number) or Aggr ( sum (Distinct Number), Period) doesn't work..

Thanks

luca

Messaggio modificato da luca

Re: Sum of rows

maxgro — Mon, 07 Apr 2014 09:33:44 GMT

use a chart (straigth table) with

dimension Period

expression sum(Number)

Re: Sum of rows

Mon, 07 Apr 2014 09:37:16 GMT

I'va already done that, but i.e. for A I have 300, not 50..

Re: Sum of rows

maxgro — Mon, 07 Apr 2014 09:40:59 GMT

post your qlikview doc, if possible

I think you have some other fields other than Period

Re: Sum of rows

Mon, 07 Apr 2014 09:41:21 GMT

Hi,

Try this it may helpful....

sum(total aggr(nondistinct sum(Number),Period,date))

Thanks,

ASHOK

Re: Sum of rows

arjunkrishnan — Mon, 07 Apr 2014 09:43:18 GMT

Hi luca,

Sum(Number) -> Use This Expression in Straight Table

Aggr(Sum(Number),Type)

Re: Sum of rows

Mon, 07 Apr 2014 09:48:25 GMT

Yes, I have another field in my table:

I thought it was not important..

Re: Sum of rows

Mon, 07 Apr 2014 09:52:34 GMT

TRY THIS ....

Re: Sum of rows

Anonymous — Tue, 08 Apr 2014 06:21:12 GMT

Hi,

Take a straight table. Use period as dimension and sum(value) as Expression..U should get it.

Re: Sum of rows

Tue, 08 Apr 2014 09:44:41 GMT

Instead of using Aggr function, use total function.

This will show the sum of number across period.

Try the below expression:

sum(total<Period>number)

Hope this will help you..!

Re: Sum of rows

nizamsha — Tue, 08 Apr 2014 10:02:41 GMT

Look at The Attachment