topic sum IN FIELD in QlikView

sum IN FIELD

Mon, 28 Sep 2009 19:08:34 GMT

Hi ,

the field !"A" icontains 3 rows :

100

-50

I would the sum of this field (100) in a new field .

I tried:

numsum(A) as second Field

but do noy work

Thanks

sum IN FIELD

prieper — Mon, 28 Sep 2009 19:22:19 GMT

Why would you want to do?

Peter

sum IN FIELD

Mon, 28 Sep 2009 19:35:44 GMT

I have 3 fields:

Entry Group no : 600

Entry no: 100,200,101

amount: 100,50,-50

Entry Group no : is linked to 3 Entry no: and also the value of this entries (amount)

I woyld to have the total (sum of amount) of Entry Group no

thanks

Best regards

sum IN FIELD

prieper — Mon, 28 Sep 2009 19:40:20 GMT

Still not quite clear to me, in a script you may achieve this by
LOAD [Entry Group no], SUM(amount) FROM .... GROUP BY [Entry Group no]
in a straight table just take [Entry Group no] as dimension and enter SUM(amount) as expression

Peter

sum IN FIELD

Mon, 28 Sep 2009 19:47:14 GMT

No,no ..

I would get the result in RUNTIME

I tried sum and group by but I woyld get Total Amount in Field

ILoad a,b, sum(amount) as total Group by(a,b, amount; Sql Select ...

the new field total is the total; in this case 100

( 100-50+50)

I would the t"total" field contains 100 like value

sum IN FIELD

Mon, 28 Sep 2009 20:49:08 GMT

I solved. The group by is used Just a dimension not a expression.

Thanks

Best Regards

Slash