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
Highlighted
Not applicable

NPV Bar and Line Graph

Hello,

What I am trying to graph is Bar and Line graph which will demonstrate the following.

Bars: monthly lease payments which have their leases terminate that month.

Line: this would be the NPV of all future lease payments including the current month.

So for a 3 month Period, the line in Jan would be the NPV of the leases in Jan, Feb, Mar while the bar would be the $ amount of monthly payments whose leases terminate in Jan. Feb line would be NPV of Feb and Mar and the bar would be the amount of leases terminating in Feb. and for March the same.

What I'm looking for is the expression for the line graph. I have the bar graph which works but can't get a line graph which will NPV the forward payments. If NPV is not possible then just to sum the future payments (bars) for each month would be good and I can work from there, a kind of reverse accumulation.

Thank you in advance for your help.

Tags (2)
1 Reply
Partner
Partner

NPV Bar and Line Graph

Hi,

Did you find any solution to your problem? How did you solve that, because I am facing a familiar problem with yours.

Thanks a lot,

Helen