Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Resolving partial sums - For loop?

Hi all,

I have an interesting issue I am about to take on. I need to calculate a partial sum.

Y = T - aΣ x/(1+b)^i


Where the partial sum (Σ) is from i=1 to n and varies for each record between 1 and 25. Basically all of the terms of the equation are known and are in a single row of a table except for y. Each record has this single row of known terms.


I would like to add a column to the table for y using the data from that single row into this equation.


How do I get this partial sum to resolve? Is a For loop in the script my best option?

Many thanks,

Mike

Tags (1)
Community Browser