topic Re: Values are split in different rows for same Code in QlikView

Values are split in different rows for same Code

Tue, 09 Sep 2014 12:42:16 GMT

COMP_CODE	CS_COMP_CODE	CLM_COMP_CODE	COMP_NAME	LYTD Claims
				423423689
1	1	1	XYZ Company	130105870.7
1	6	6	XYZ Company	758898.667
2	2	2	XYZ Company, Dubai	248525030.4
3	3	3	XYZ Company, Abu Dhabi	36960129.95
5	5	5	XYZ Company	943114.697
6	6	6	XYZ Company	3990743.397
-	1	1	-	42805.3
-	5	5	-	1013763.197
-	6	6	-	1842231.443

Comp_Code is from the master table. cs_comp_code and CLM_comp_Code are from different tables.

Error : The results are splited out in different rows. first 3 columns should have same code. LYTD claims should have consolidated value eg: Actual result for CompCode should be 130105870.7 + 42805.3, but they r in different rows, when i try to link with other tables loops are being formed. Pls help

Message was edited by: jasmine Glory

Re: Values are split in different rows for same Code

anbu1984 — Tue, 09 Sep 2014 13:24:13 GMT

Can you post sample app

Re: Values are split in different rows for same Code

fkeuroglian — Tue, 09 Sep 2014 13:40:10 GMT

Put an example please or explain more, will be easier to help you

Fernando

Re: Values are split in different rows for same Code

rubenmarin — Tue, 09 Sep 2014 14:11:30 GMT

Hi Jasmine,

There are some records without value for COMP_CODE, it's hard say a solution without more info, in script you can try something like:

If(IsNull(COMP_CODE), CS_COMP_CODE, COMP_CODE) as COMP_CODE

or loading the field 'CS_COMP_CODE as COMP_CODE' when you read the source data without value in COMP_CODE

Hope this helps you to find the right solution.

Regards.

Re: Values are split in different rows for same Code

Tue, 09 Sep 2014 14:16:09 GMT

COMP_CODE	CS_COMP_CODE	CLM_COMP_CODE	COMP_NAME	LYTD Claims	Comments
				423423689	Total Value
1	1	1	XYZ Company	130105870.7 + 42805.3	last but 3rd row should be added here with codes 1,1,1 in the first 3 columns
1	6	6	XYZ Company	758898.667	This row should not be there (duplicate)
2	2	2	XYZ Company, Dubai	248525030.4	No change
3	3	3	XYZ Company, Abu Dhabi	36960129.95	No change
5	5	5	XYZ Insurance Company	943114.697 + 1013763.197	last but 2nd row should be added here
6	6	6	XYZ Company	3990743.397 + 1842231.443	No change