topic Re: Sript error in QlikView

Sript error

Wed, 26 Nov 2014 03:14:48 GMT

Dear all,

I have attached my sample data.

In my data base I have some products with same product code which have different selling prices and different commission patterns in the range of "Personal Product".

What i did in my commission calculation,

I introduced extended product codes to my commission rate(COMRATES.XLS) file and to the product mater file (BS-MF.xls). And also renamed the product codes in the data base through the script.

But the calculation dose not give the expected answer. As per my observation renaming in the script dose not works.

Can anyone help me to change the script to have proper result.

Regards,

Priyantha

Re: Sript error

jagan — Wed, 26 Nov 2014 03:45:24 GMT

Hi,

Can you explain with some sample example and your expected output?

Regards,

Jagan.

Re: Sript error

Wed, 26 Nov 2014 04:23:04 GMT

BCOD	ORC_CODE	CLA_CODE	PRD_CODE	REF_NO	GL_CODE	PREMUM	BRO_ORC	AGE_ORC	GRO_ORC	DIRECT_ME	ORC_COM	EXCESS
WW00	54042	PP	SE	WW0014D0004846	70740	1201	0	0	0	108	130	-22
				WW0014D0004847	70740	1201	0	0	0	108	130	-22
				WW0014D0004858	70740	1201	0	0	0	108	130	-22
				WW0014D0004859	70740	1201	0	0	0	108	130	-22
	54945	PP	SE	WW0014D0004831	70740	1201	0	0	0	108	130	-22
				WW0014D0004832	70740	1201	0	0	0	108	130	-22
				WW0014D0004834	70740	1201	0	0	0	108	130	-22
				WW0014D0004850	70740	1201	0	0	0	108	130	-22
				WW0014D0004865	70740	557	0	0	0	50	30	20
	54997	PP	SE	WW0014D0004835	70740	557	0	0	0	50	50	0
				WW0014D0004852	70740	557	0	0	0	50	50	0
				WW0014D0004866	70740	1201	0	0	0	108	120	-12
				WW0014D0004867	70740	858	0	0	0	77	30	47

Dear Jagan,

In the above table there are three "PREMIUMS" available with same "CLA_CODE"and "PRD_CODE" with different commission structures. The calculation should be done in "DIRECT_ME" colomn. Expexted results should be like below.

PREMIUM DIRECT_ME

557 50

858 90

1201

130

If you see my script i have renamed the 'PRD_CODE' and introduced the same to the product master file and the commission rate master file.

Please help,

Regards,

Priyantha