Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Excel formula in Qlikview

Hi,

    Can anyone help me out with this formula. Column C (factor) in the attached excel is calculated from A and B. the formula is

1+SUM(B3:B$62)/SUM(B$2:B2).

Please check and let me know if this is possible in Qlikview and how it can be achieved.

Thanks in advance.

Lax

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Excel formula in Qlikview

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.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Excel formula in Qlikview

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.


talk is cheap, supply exceeds demand

View solution in original post