topic Re: Profit and loss using intervalmatch in QlikView

Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 06:25:24 GMT

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

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 06:34:17 GMT

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

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 07:46:53 GMT

anyone done this before?

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 08:02:40 GMT

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

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 08:25:59 GMT

hi please check this jagan‌

Re: Profit and loss using intervalmatch

Mon, 04 May 2015 08:36:56 GMT

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

Thanks!!

Re: Profit and loss using intervalmatch

Mon, 04 May 2015 08:37:51 GMT

And account.qvd if possible.

Re: Profit and loss using intervalmatch

Mon, 04 May 2015 09:06:04 GMT

also need the trial balance

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 09:13:43 GMT

sorry not possible to share. large dataset

Re: Profit and loss using intervalmatch

Mon, 04 May 2015 09:16:36 GMT

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

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 09:18:03 GMT

TBAL_MTD_CR_LC_1 and TBAL_MTD_DR_LC_1 is amount. you can consider any amount

Re: Profit and loss using intervalmatch

Mon, 04 May 2015 09:26:01 GMT

Now please use this and check whether this will help you or not?

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 09:30:43 GMT

thanks what i need is check the expected output above

for example

1- Gross premiums	100
3- Movement in unexpired premium	200
3- Movement in unexpired premium+Net premium	300
4- Net Commision	400
5- Gross claims	500
6- Reinsurance and other recoveries	600
5- Gross claims+6- Reinsurance and other recoveries	1100

Re: Profit and loss using intervalmatch

arulsettu — Mon, 04 May 2015 09:59:40 GMT

does any one clarify the parameter i passed in intervalmatch cause the problem?

any ideas will be appreciated its very urgent

Thanks

Re: Profit and loss using intervalmatch

jagan — Tue, 05 May 2015 03:50:52 GMT

Hi Arul,

Your data has the issue I think. ACNT_CMP_CODE is matching with multiple Start and End value. Please check below that Code 001 is matching with 7 Start and End values. I think this is causing the issue.

ACNT_COMP_CODE	ExecPLEnd	ExecPLStart
001	1	1
001	3	1
001	4	1
001	8	1
001	12	1
001	18	1
001	20	1
002	2	2
002	3	1
002	4	1
002	8	1
002	12	1
002	18	1
002	20	1
003	3	1
003	3	3
003	4	1
003	8	1
003	12	1
003	18	1
003	20	1
005	5	5
005	8	1
005	12	1
005	18	1
005	20	1
	4	4
	6	6
	7	6
	7	7
	8	6
	8	8
	9	9
	10	10
	11	11
	12	9
	12	12
	13	13
	14	14
	15	15
	16	16
	17	17
	18	13
	18	18
	19	19

Re: Profit and loss using intervalmatch

arulsettu — Tue, 05 May 2015 03:58:16 GMT

Hi Jagan,

i created that start and end in a excel file according to this

How to Create a Profit and Loss Statement in QlikView

can you please tell me how to do it?

Thanks

Re: Profit and loss using intervalmatch

arulsettu — Tue, 05 May 2015 08:12:16 GMT

this is expected output

ACNT_COMP_CODE	ExecPLEnd	ExecPLStart
001	1	1
001	3	1
001	4	1
001	8	1
001	12	1
001	18	1
001	20	1
002	2	2
002	3	1
002	4	1
002	8	1
002	12	1
002	18	1
002	20	1
003	3	1
003	3	3
003	4	1
003	8	1
003	12	1
003	18	1
003	20	1
005	5	5
005	8	1
005	12	1
005	18	1
005	20	1
	4	4
	6	6
	7	6
	7	7
	8	6
	8	8
	9	9
	10	10
	11	11
	12	9
	12	12
	13	13
	14	14
	15	15
	16	16
	17	17
	18	13
	18	18
	19	19

ACNT_COMP_CODE	ExecPLEnd	ExecPLStart
001	1	1
001	3	1
001	4	1
001	8	1
001	12	1
001	18	1
001	20	1
002	2	2
002	3	1
002	4	1
002	8	1
002	12	1
002	18	1
002	20	1
003	3	1
003	3	3
003	4	1
003	8	1
003	12	1
003	18	1
003	20	1
005	5	5
005	8	1
005	12	1
005	18	1
005	20	1
	4	4
	6	6
	7	6
	7	7
	8	6
	8	8
	9	9
	10	10
	11	11
	12	9
	12	12
	13	13
	14	14
	15	15
	16	16
	17	17
	18	13
	18	18
	19	19

ACNT_COMP_CODE	ExecPLEnd	ExecPLStart
001	1	1
001	3	1
001	4	1
001	8	1
001	12	1
001	18	1
001	20	1
002	2	2
002	3	1
002	4	1
002	8	1
002	12	1
002	18	1
002	20	1
003	3	1
003	3	3
003	4	1
003	8	1
003	12	1
003	18	1
003	20	1
005	5	5
005	8	1
005	12	1
005	18	1
005	20	1
	4	4
	6	6
	7	6
	7	7
	8	6
	8	8
	9	9
	10	10
	11	11
	12	9
	12	12
	13	13
	14	14
	15	15
	16	16
	17	17
	18	13
	18	18
	19	19