Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUM in load script doesn't work

Hey users!

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

This is my load script:

sum_load_script.jpg

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

12 Replies
Not applicable
Author

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

Not applicable
Author

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

hic
Former Employee
Former Employee

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

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

HIC