topic Re: sum of Column. in QlikView

sum of Column.

Wed, 21 Oct 2015 02:25:22 GMT

I have a column called Current with values as below.

6,494.00

39,253.00

56,00.00

481,216.00

12,000.00

19,330.00

When I put sum(Current) in text box I get 7371516 as a return value where as the sum has to be in '$' amount $614,293 .

Am I doing something wrong here ?

Thank you.@

qlikviewwizard — Wed, 21 Oct 2015 03:45:23 GMT

Hi,

Your total value is different from your sum.

Please check the below script and screens. Hope this will help you.

Data:

Load * inline [

SNo,Value

1,0

2,6494.00

3,39253.00

4,5600.00

5,481216.00

6,12000.00

7,19330.00

];

Output:

HirisH_V7 — Wed, 21 Oct 2015 03:49:36 GMT

Hi,

Please use ,Expression Like this ,

=Num(Sum(Column),'$#,##0.00;($#,##0.00)')

I Hope this helps .

Regards,

Hirish

raman_rastogi — Wed, 21 Oct 2015 04:03:06 GMT

you can change Number property of object to add $ sign.

Wed, 21 Oct 2015 15:22:49 GMT

Thank you but I cannot see the logic in the link. What expression do you have in the text objcet ?

qlikviewwizard — Thu, 22 Oct 2015 02:02:27 GMT

This logic:

='Total =$' &num(sum(Value),'#,##0')