topic Creating and Graphing NPV in QlikView https://community.qlik.com/t5/QlikView/Creating-and-Graphing-NPV/m-p/169802#M40473 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>Searched for the past hour and couldn't find anything on this, so here it is...</P><P>I'm trying to calculate and graph NPV over 15 years. The calculations are no problem, but are slightly different for each year, with year "zero" being very different. I also have user set variables that allow folks to change such things as cost of capital, years to depreciate, etc...</P><P>I've done this in the past by having a different expression for each year (set up as a bar chart, ie Year 0, Year 1...Year 14, Year 15 all as their own expressions.</P><P>Is there some way, to have one or two dimensions, and only one expression, that would read the 0-15 Year calculations for each year? Some way to make a kind of cross-table within QV, not the load function, to show NPV per Year?</P><P>Just brainstorming, I think it can be done with a series of macros, exporting to text files, then reloading and reading from the reloaded data, but am wondering if there are some other possibilities...</P><P>For arguments sake, lets say this is the only base data to load:</P><P>Site, Current Cost</P><P>We'd use a series of variable input boxes to provide the other calculation needs and to calculate Year 1 through Year 15 costs.</P><P>The end result would be NPV per Year in a line graph...</P><P>Any ideas? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Tue, 01 Dec 2009 06:33:06 GMT 2009-12-01T06:33:06Z Creating and Graphing NPV https://community.qlik.com/t5/QlikView/Creating-and-Graphing-NPV/m-p/169802#M40473 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>Searched for the past hour and couldn't find anything on this, so here it is...</P><P>I'm trying to calculate and graph NPV over 15 years. The calculations are no problem, but are slightly different for each year, with year "zero" being very different. I also have user set variables that allow folks to change such things as cost of capital, years to depreciate, etc...</P><P>I've done this in the past by having a different expression for each year (set up as a bar chart, ie Year 0, Year 1...Year 14, Year 15 all as their own expressions.</P><P>Is there some way, to have one or two dimensions, and only one expression, that would read the 0-15 Year calculations for each year? Some way to make a kind of cross-table within QV, not the load function, to show NPV per Year?</P><P>Just brainstorming, I think it can be done with a series of macros, exporting to text files, then reloading and reading from the reloaded data, but am wondering if there are some other possibilities...</P><P>For arguments sake, lets say this is the only base data to load:</P><P>Site, Current Cost</P><P>We'd use a series of variable input boxes to provide the other calculation needs and to calculate Year 1 through Year 15 costs.</P><P>The end result would be NPV per Year in a line graph...</P><P>Any ideas? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Tue, 01 Dec 2009 06:33:06 GMT https://community.qlik.com/t5/QlikView/Creating-and-Graphing-NPV/m-p/169802#M40473 2009-12-01T06:33:06Z Re: Creating and Graphing NPV https://community.qlik.com/t5/QlikView/Creating-and-Graphing-NPV/m-p/169803#M40474 <HTML><HEAD></HEAD><BODY><P>please help.</P><P></P><P>I am facing the same problem</P></BODY></HTML> Thu, 07 Feb 2013 14:00:47 GMT https://community.qlik.com/t5/QlikView/Creating-and-Graphing-NPV/m-p/169803#M40474 2013-02-07T14:00:47Z