topic Re: Referencing expression from row above in QlikView

Referencing expression from row above

Anonymous — Tue, 03 Jan 2017 18:47:13 GMT

Hello,

I have tried using the Above() function for this, but it is not working as I hoped or I am doing something wrong. The attached spreadsheet illustrates the type of calcs and functionality I am looking to replicate in QV. I am assuming that I start with $100 in cash and buy something so the ending balance is the starting balance less what I have bought. The beginning balance for the next row is the ending balance from the row above. For each row > 1 I earn interest on the beginning cash balance which becomes part of the ending cash balance.

I need to make the "something" that I buy/sell dynamic in that the user can enter a "multiplier" to increase the size and have everything dynamically recalculate. The calc I cannot figure out is the beginning cash balance for RowNum > 1

Any help/advice is appreciated.

Chris

Re: Referencing expression from row above

sunny_talwar — Tue, 03 Jan 2017 19:04:54 GMT

End share calculation seems different, otherwise it seems to be working

Re: Referencing expression from row above

Anonymous — Tue, 03 Jan 2017 19:28:19 GMT

Thank you Sunny!

I have to admit I am not really sure why the RangeSum function is necessary, but it seems to work. I will have to read up to understand your solution better.

Chris

Re: Referencing expression from row above

sunny_talwar — Tue, 03 Jan 2017 19:35:31 GMT

The problem was that Net BuySell is null and when you do something like this

Not Null + Null = Null

But, this works

RangeSum(Not Null, Null) = Not Null

I hope this will clarify your doubts.

I would suggest closing this thread by marking Correct and/or helpful responses so that future visitors can benefits here.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny