Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
giakoum
Partner - Master II
Partner - Master II

This is a tricky one...

Hi all.

I need to make a complex calculation, preferably as a variable.

I have made it by using a straight table, but now I need to convert it to a single formula. The desired result is the sum of rows of column Final (see attached QV file). What I want to achieve is having the user type in a QTY (variable) and use this quantity in the calculation. But this quantity needs to be only used once in the cummulation done in column 3.

Please see attached QV, it will make the case clear.

Thank you for your help.

giakoum

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II
Author

I figured it out myself :

Variable1 - rangesum(above((Cummulative),1,RowNo())) - Cummulative

View solution in original post

3 Replies
Michiel_QV_Fan
Specialist
Specialist

If I get it right you mean:

(RangeSum(Column(2)-Column(1), Above(Column(3))))+$(Variable1)

If not, I didn't get it

giakoum
Partner - Master II
Partner - Master II
Author

No this is not it. I do not want the variable to be added in every row, only the first, and the result to be added in the 2nd and so on.

And I would like to change column(1) and column(2) etc to the real expressions so that I can make one expression of it and not having it on the straight table.

giakoum
Partner - Master II
Partner - Master II
Author

I figured it out myself :

Variable1 - rangesum(above((Cummulative),1,RowNo())) - Cummulative