Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

field lookup from the row above from a different column

Hi there,

I need assistance please as I have been battling for a few hours.

How would I go about to add the difference from Q1 (11) to Q2 in the completed column making it 38? This will in turn change the difference for Q2 which will have to be added to the Q3 completed value and so on.

Any assistance will be much appreciated.

3 Replies
sunny_talwar

May be this

RangeSum(Completed, Above(Diff))

swuehl
MVP
MVP

For Completed, use something like

=Rangesum(Above( Completed, 0, Rowno() )) - Rangesum(Above(Due, 1, Rowno() ))

Keep Due Unchanged.

Calculate Diff as

=Column(1) - Column(2)

edit: If you are using some aggregations in your expressions to calculcate Completed, etc.:


=Rangesum(Above( Sum(CompletedField), 0, Rowno() )) - Rangesum(Above( Sum(DueField), 1, Rowno() ))

Anonymous
Not applicable
Author

Thanks Sunny and Stefan....RangeSum(Above(Diff)) works perfectly