Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

giakoum
Honored Contributor 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
Honored Contributor II

Re: This is a tricky one...

I figured it out myself :

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

3 Replies
michielvandegoo
Valued Contributor

This is a tricky one...

If I get it right you mean:

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

If not, I didn't get it

giakoum
Honored Contributor II

Re: This is a tricky one...

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
Honored Contributor II

Re: This is a tricky one...

I figured it out myself :

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

Community Browser