Discussion Board for collaboration related to QlikView App Development.
Can anyone help me out with this formula. Column C (factor) in the attached excel is calculated from A and B. the formula is
Please check and let me know if this is possible in Qlikview and how it can be achieved.
Thanks in advance.
Go to Solution.
Try this expression:
1+rangesum(below(total sum([Policy Count]),1,61-RowNo(TOTAL)))/ rangesum(above(total sum([Policy Count]),0,RowNo(TOTAL)))
See attached qvw.
View solution in original post