Profit and loss using intervalmatch

[arulsettu]

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

[arulsettu]

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

[arulsettu]

anyone done this before?

[arulsettu]

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

[arulsettu]

hi please check this jagan‌

[#6]

I would need trail balance qvd.. if possible please share

Thanks!!

[#7]

And account.qvd if possible.

[#8]

also need the trial balance

[arulsettu]

sorry not possible to share. large dataset

[#10]

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