topic Re: Sum() operation in Scripting in QlikView

Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:01:52 GMT

Hi all,

I was working on a requirement where i have to count the Sum(Units Sold) per Name and per Place.

So, i did Sum(Units Sold) group by Name , Place in the script and loaded it as a dimension.

It worked but the problem is ..

Eg:

when the units sold is only one value i.e. 10 for Name A - Its not getting counted,

where as if the units were 10 and 5 its getting counted as 15.

Can anyone help me on this.

Re: Sum() operation in Scripting

alexandros17 — Mon, 31 Aug 2015 15:03:37 GMT

Could you please send an example?

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:16:45 GMT

Please find the app.

I was wondering why am i not able to display all values in the chart

Re: Sum() operation in Scripting

Anonymous — Mon, 31 Aug 2015 15:17:42 GMT

use

=sum("Sum([Units Sold])")

as expression

Re: Sum() operation in Scripting

settu_periasamy — Mon, 31 Aug 2015 15:20:51 GMT

for better understanding you can give the alias name in the script like.

Load Name, Place,

Sum([Units Sold]) as [Unit Sold] Group by Name, Place;

then you can use the expression Sum([Unit Sold])

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:21:35 GMT

Hi,

Tried that too..

but not working.

The problem is when i'm summing in the script and storing in a dimension...the single values were not getting summed up and so i cannot see the same in the front end.

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:22:27 GMT

Hi,

The problem is when i'm summing in the script and storing in a dimension...the single values were not getting summed up and so i cannot see the same in the front end.

Re: Sum() operation in Scripting

alexandros17 — Mon, 31 Aug 2015 15:23:42 GMT

But why you need to use a Group by?

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:25:28 GMT

because i want to sum the units by Name and Place..

If there is any way without using the group..please let me know

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 15:28:18 GMT

A B

2 4

In my original application, when im using sum() it is counting 5 for A.

But not 4 for B.

It is not summing when there is only one value..

Hope i'm clear.

Re: Sum() operation in Scripting

alexandros17 — Mon, 31 Aug 2015 15:31:38 GMT

very strange, can you share your original app?

Re: Sum() operation in Scripting

settu_periasamy — Mon, 31 Aug 2015 15:32:55 GMT

Hi,

A,B is a field name or data?

if you post the good example in excel or qvw, we can try to find the solution

Re: Sum() operation in Scripting

Mon, 31 Aug 2015 15:33:47 GMT

Hi,

Can't you add Name and place as dimensions as below to get the result!

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 18:53:57 GMT

Hi,

I did it in the front end, it worked.

Thank you very much.

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 18:54:24 GMT

Thanq kiru devi.

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 18:54:37 GMT

Thanq Rudolf

Re: Sum() operation in Scripting

markgraham123 — Mon, 31 Aug 2015 18:54:58 GMT

Thanq periasamy.