topic Re: This is a tricky one... in QlikView

This is a tricky one...

giakoum — Fri, 08 Jun 2012 09:07:05 GMT

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

This is a tricky one...

Michiel_QV_Fan — Fri, 08 Jun 2012 09:22:49 GMT

If I get it right you mean:

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

If not, I didn't get it

Re: This is a tricky one...

giakoum — Fri, 08 Jun 2012 09:31:30 GMT

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.

Re: This is a tricky one...

giakoum — Fri, 08 Jun 2012 10:43:44 GMT

I figured it out myself :

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