Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i am calculating profit and loss. in a straight table doing row wise calculation.so i followed below link
How to Create a Profit and Loss Statement in QlikView
so i created a excel table also. but i am unable to get the result. getting repeated values only.
can anyone check and tell what i am doing wrong
i followed the link and did everything as it is. my doubt the parameter i passed in the intervalmatch is the problem? or the excel file i created?
its urgent please someone suggest any solutions
thanks
anyone done this before?
expected output is based on the excel above
1- Gross premiums |
3- Movement in unexpired premium |
3- Movement in unexpired premium+Net premium |
4- Net Commision |
5- Gross claims |
6- Reinsurance and other recoveries |
5- Gross claims+6- Reinsurance and other recoveries |
8- Movement in outstanding claims |
Net Claims+8- Movement in outstanding claims |
Net earned premium+Net commission+Incurred Claims |
Operative and administrative expenses |
Depreciation of property and equipment |
Group shared expenses |
Above 4 rows |
Income from underwriting+Total Expenses |
Investment income |
Intercompany Facility interest |
Intercompany Dividend |
Advisory fee income |
Other Income |
Above 6 rows |
Operating Income+Total Investment & Other Income |
Profit for the period before BOD remuneration & expenses-BOD Remuneration & expenses |
hi please check this jagan
I would need trail balance qvd.. if possible please share
Thanks!!
And account.qvd if possible.
also need the trial balance
sorry not possible to share. large dataset
i just wanted to understand what is TBAL_MTD_CR_LC_1 and TBAL_MTD_DR_LC_1 and i hope you are loading the data through qvd which is not a big data to share. if it confidential and connot be shared then pls let me know what is it that i have to consider so that i will prepare the in excel and load these two parameters for calculation