Discussion board where members can get started with QlikView.
I want build one logic i,e I have a data like below file.
Logic is In col2 i have level type ,If i m in A1 level i dont want diff, if i enter into nxt level means A2 iwant to take diff above of record..
Output i want is :
May be this:
=If(Aggr(NODISTINCT RowNo(), Col, Col2) > 1, RangeSum(Sum(Col4) - Above(TOTAL Sum(Col4))))
View solution in original post
How are you getting this 4? Is that correct or typo?