Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Calculate NPV


Hi,

I know this shouldn't be that difficult, but somehow, it is.

Here's the issue. I need to learn how to calculate a simple Net Prsent Value in Qlikview.

Total Costs - 1.279 mln

Cash Flows -

200k

233k

233k

233k

233k

rate - 20%

The answer should be a negative NPV of -609.7k.

I am not an expert in sql, so I am a bit confused.

Thanks in advance

Tom

10 Replies
Clever_Anjos
Employee
Employee

Sorry, never worked with this function