Sum of rows

[#1]

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

[maxgro]

use a chart (straigth table) with

dimension      Period

expression     sum(Number)

[#3]

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

[maxgro]

post your qlikview doc, if possible

I think you have some other fields other than Period

[#5]

Hi,

Try this it may helpful....

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

Thanks,

ASHOK

[arjunkrishnan]

Hi luca,

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

Aggr(Sum(Number),Type)

[#7]

Yes, I have another field in my table:

I thought it was not important..

[#8]

TRY THIS ....

[Anonymous]

Hi,

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

[#10]

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