
using line() or row() like column()
Stefan Wühl Aug 30, 2011 8:16 AM (in response to Andreas Dippel)Interesting, a row() seems to be missing.
What could work is using chart inter record function top(), like
top(YOUREXPRESSION,N)
to evaluate your expression in the context of Nth row. You probably need a conditional expression, but for example, this worked in a total row (checking for rowno()=0) like =if(rowno()=0,top(sum(Sales),1)top(sum(Sales),2))
to subtract sum Sales in context of row 1  row2.
Stefan

Re: using line() in formula instead of column()
Andreas Dippel Aug 31, 2011 5:18 AM (in response to Stefan Wühl )for formulas, which only need to use 1 row, its seems to be sufficient, to assign a row by using
top(coloumn(2),1) for the first cell in coloumn 2.
but if its necessary to use the formula with more than one row, we need a "row()" function.
or we use the suggestioon by "swuehl": (coloumn(2),n) where we get "n" by counting rows.
this could be made much simpler, and less prone to failures with an introduction of "row()" in qlickview 10
