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.
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