topic Re: SUM in load script doesn't work in QlikView

SUM in load script doesn't work

Mon, 29 Apr 2013 10:01:55 GMT

Hey users!

My question is very easy and I wonder that I don't get it.

This is my load script:

The result is, that it shows me the two field again, but I want a sum. It has to sum the values. 3 + 6 = 9. I thought that's what sum do!

Thanks for you help!

Your Sometimes-Desperate-Inga

Re: SUM in load script doesn't work

hic — Mon, 29 Apr 2013 10:21:19 GMT

No, Sum() only works together with a Group By. If you want to accumulate, you should use

Rangesum(Peek(Kumuliert),Betrag) as Kumuliert.

And make sure that it is correctly sorted...

HIC

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 10:32:36 GMT

At script label,

if you are using

sum(@56) as [kumuliert: Ausleihen gesamt ]

then must be used groupby.

**********************************************

you can simply try in your expression

sum(Total(@56))

Re: SUM in load script doesn't work

sivarajs — Mon, 29 Apr 2013 11:31:17 GMT

Since you are grouping by signatur it wont give you total 9 because if you note the signatur, both the values are different. So it wont get sum up

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 11:46:35 GMT

Perhaps, I can show better what I've done, if you see my group by.

Hmmm, for example the 38 is grouped. But... There must be 106. And if I mark The 1 and the 21 in the table, there should be a 22.

Can you show me how to fill in in your rangesum-command? I don't get it.

Thanks for your help,

Inga

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 11:59:04 GMT

Here you can see my group by. No, sum(total () ) doesn't work. But it was a good try.

Thanks for your help.

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 12:25:51 GMT

Hi,

1)Use group by, as Sum() in load script always works with Group by.

2) Since,you are using the signatur field as dimension and since it has got two different values.

so the data gets bifurcated and you get two values 6 and 3 respectively.

Hope this helps,

Regards,

Snehal Nabar

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 12:29:42 GMT

Sum(Total(@56)) work in expression of Pivote table.

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 12:59:41 GMT

Hi,

1)Use group by, as Sum() in load script always works with Group by.

2) Since,you are using the signatur field as dimension and since it has got two different values.

so the data gets bifurcated and you get two values 6 and 3 respectively.

Hope this helps,

Regards,

Snehal Nabar

Re: SUM in load script doesn't work

hic — Mon, 29 Apr 2013 13:13:08 GMT

The best solution for accumulation is often not to do it in the script. Instead you should do it in a chart/pivot table.

If you just load the data you have without any group by in the script, and then create a chart where you define two expressions:

Sum([Ausleihen gesamt])

RangeSum(Above(Kumuliert), Sum([Ausleihen gesamt]))

and label the second expression "Kumuliert", then I think you will get what you want.

HIC

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 14:12:22 GMT

Hello Henric,

yes, the easy way is to create a listbox or a statistics box. I created a statistics box and sum the [Ausleihen gesamt]. It's nice to see, that it works, but for futher calculations I need a field and no object. It's terrible, but I don't give up.

Thanks,

Inga

Re: SUM in load script doesn't work

Mon, 29 Apr 2013 14:15:32 GMT

Hi Snehal,

wooow, I can't believe that I desperate on a sum. 😄

1) Yes, I have the exact field in my group by.

2) I deactivate "Signatur" but it doesn't work. It's the same problem.

I helped now with a statistics-box, but for futher calculations I can't use the objects.

Thanks for your help!

Inga

Re: SUM in load script doesn't work

hic — Mon, 29 Apr 2013 15:13:42 GMT

Well, if you want to have it in the script, you should do what I suggested earlier:

Rangesum(Peek(Kumuliert),@56) as Kumuliert

HIC