Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
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
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