update filed value after load in qvd

[#1]

hello

I have a table, its script is like 

Cashflow:

LOAD 2013 as Year, * inline [

ActivityDate|Discount|Payments|type

2016-01-01|0.1|-10000|contrib

2016-03-01|0.1|3000|Distrib

2016-10-30|0.1|4200|Distrib

2017-02-01|0.2|6800|Distrib

] (delimiter is '|');

now i want to make changes in table object and how would correspondingly i will get updated field values??

[#2]

Hello skumargen2,

Can you please tell me what exactly do you want to change? Unfortunately I do not understand what are you trying to achieve here...

If you are asking about how to amend and add up to initial data-set, here is an example:

LOAD
*,
[Discount Value]*0.23 as [Discount Tax Value]
;
LOAD
*,
2013 as Year
,Payments*Discount as [Discount Value]
,year(ActivityDate) as [True Year]
inline [
ActivityDate|Discount|Payments|type
2016-01-01|0.1|-10000|contrib
2016-03-01|0.1|3000|Distrib
2016-10-30|0.1|4200|Distrib
2017-02-01|0.2|6800|Distrib
] (delimiter is '|');

This is called preceding load, and there is a great blog post, introducing its concepts: community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

BR,

Kuba

[#3]

hi jacub , sorry for late reply

i want to make a table chart which will be holding activity date,payment. now i want to calculate xirr(payment, date) by using filed values. now if i make some changes in table chart , then i want updated field values of payment and date ?? how to do it? bcoz if i have updated filed values of payment and date then only neww xirr value i can get.

thanks for ur reply