topic Re: sum in table in QlikView

sum in table

Mon, 07 Apr 2014 10:44:46 GMT

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

Re: sum in table

lironbaram — Mon, 07 Apr 2014 11:01:01 GMT

you should build a table

with period as the dimension and sum(Number) as the expression

Re: sum in table

cfz — Mon, 07 Apr 2014 11:08:22 GMT

Hi Luca,

The easiest way is to use a pivot table and do a simple sum as in the example. Otherwise in order to be able to help you I would nee to know how the table needs to look like, that, is with dimensions must be present and where in the table the different results 6, 4, 50 need to appear. A screenshot of the desired table would be great to avoid misunderstanding.

Kind regards

Carlos

Re: sum in table

Mon, 07 Apr 2014 11:08:35 GMT

Thanks Liron.

I'va already build a table, but doesn't work. The field Type does not allow a simple sum (Number)..

Re: sum in table

sujeetsingh — Mon, 07 Apr 2014 11:09:57 GMT

See this sample