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]

TBAL_MTD_CR_LC_1  and TBAL_MTD_DR_LC_1 is amount. you can consider any amount

[#3]

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

[arulsettu]

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

[arulsettu]

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

any ideas will be appreciated its very urgent

Thanks

[jagan]

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

[arulsettu]

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

[arulsettu]

this is expected output