Discussion board where members can get started with QlikView.
I have an excel file which has data like below
% calc is field I need to derive in qlikview.
The way it is calculated as is
(20+30+40+50)/(10+20+30+40+50)=0.933.. similarly (30+40+50)/(20+30+40+50)=0.8571.
I tried different combination of Rangesum function but it didn't work.
Please help. Attach is the file
May be this
=Above(Sum(TOTAL [Cleared Status]) - RangeSum(Above(Sum([Cleared Status]), 0, RowNo())))/Above(Sum(TOTAL [Cleared Status]) - RangeSum(Above(Sum([Cleared Status]), 1, RowNo())))
View solution in original post