possible in which way?

[arulsettu]

Hi,

     i am trying to do something like in following excel. so i followed everything according to this concept

How to Create a Profit and Loss Statement in QlikView

but i cant able to achieve what i need.

can anyone tell me how to achieve this

Thanks

[arulsettu]

like this i have to create reporting_code in DB 

ACNT_FLEX_04                         reporting_code

1- Gross premiums	1
2- Reinsures share of gross premiums	2
XOL Protection costs	3
3- Movement in unexpired premium	4
4- Net Commision	5
5- Gross claims	6
6- Reinsurance and other recoveries	7
8- Movement in outstanding claims	8
Operative and administrative expenses	9
Provision for doubtful debts	10
Depreciation of property and equipment	11
Group shared expenses	12
Investment income	13
Intercompany Facility interest	14
Intercompany Dividend	15
Rental income	16
Advisory fee income	17
Other Income	18

Thanks

[Peter_Cammaert · Accepted solution]

Almost. If you want to know the logic behind what I'm going to explain, reread the technical brief. It would be even more instructive if you rebuild step-by-step the P&L as documented by Jennell, based on her data instead of jumping straight into your own challenges.

The Reporting Codes that you should assign to the accounts in your chart of accounts are taken from your Excel (see income_statement_new.xls). The Excel has two columns ExecPLStart and ExecPLEnd. All lines that have identical values in both columns are carrying Reporting Codes. This is almost identical to the list you supplied above, except that the last one, BOD Remuneration & expenses (19) is missing.

Now go back to your list of accounts and assign a single Reporting Code to each account number. This is where you can do with some information from your accounting dept.

Peter

[arulsettu]

Thank you very much i will check and comeback

[arulsettu]

Thanks Peter it works...

[arulsettu]

Hi Peter,

               just one doubt space between rows is not coming. i checked the excel the 's' is available.

Thanks

[Peter_Cammaert]

See Technical Brief, p8, first bullet. Did you put spaces in ...?

[arulsettu]

yes i did