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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rsaiq
Creator
Creator

Enter 2 new row in qliksense tble

Hi All,

I want to calculate insert two rows i.e(Opening & Closing)and calculate XIRR based on Opening & Closing
My data is as follows:

Rsaiq_0-1634659150148.png

What i want is the yellow lines as shown below,if user selects start date as 2018-05-31 & End Date as 2018-12-31

Rsaiq_2-1634659320631.png

 

Opening is coming by taking value(Cashflow) of start date-1(start date is 2018-05-31 and taking value of 2017-11-21).

Closing is coming Opening Value + Last Date value(Amount) *-1.

And finally XIRR as =XIRR(Cashflows,Date)

Kinddly find attach data source file.

Please help me out in the above report......

 

 

Labels (4)
0 Replies