NPV (Net percentage value)

[Rajsd]

Hi,

    How can we convert the following function from Excel to qliksense.

=NPV(0.1, value1, value2 , value3)

If i do sum of value1,Value2,value3 in qliksense,its not giving right values! 

Kindly help

[Ksrinivasan]

hi,

try this link for chart function:

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Finan...

for Script function:

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/FinancialA...

ksrinivasan

[Rajsd]

Hi @Ksrinivasan  i had seen this link before but unable to understand this and implement! Could you please elaborate

[Ksrinivasan]

hi,

seeing this link

https://www.youtube.com/watch?v=YZkmvzChQr0

ksrinivasan

[Rajsd]

Hi @Ksrinivasan  i have gone through all these videos and links but i am not getting the exact answers in the set expression! Anyways thanks for your support

[Ksrinivasan]

hi,

your table should be like this

Product  |  Rate

A | 100

B|150

C|300

your =NPV(0.1, value1: A=100, value2:B=150 , value3: C=300)

discount=0.1

formula is

NPV (0.1,Rate)

ksrinivasan

[Rajsd]

No my table is like this,

Contract id, period1, period 2, period 3

1120, 100,200,300

This is one row for one contract id that is 1120 with discount of 10 percentage.

If its one column then i would have used ur formula and got right answer but here it is multiple columns 

[Ksrinivasan]

hi,

you can bring the values in single field as below by using cross table function, then use NPV(.1,Period)

ID | Period

1120 | 100

1120 | 200

1120 | 300

ksrinivasan

[Ksrinivasan]

hi,

to know about cross table

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...

ksrinivasan

[Rajsd]

@Ksrinivasan  I have 100 fields for value1,value2.... I can't alter the load script.