Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Values are split in different rows for same Code

COMP_CODECS_COMP_CODECLM_COMP_CODECOMP_NAMELYTD Claims
423423689
111XYZ Company130105870.7
166XYZ Company758898.667
222XYZ Company, Dubai248525030.4
333XYZ Company, Abu Dhabi36960129.95
555XYZ Company943114.697
666XYZ Company3990743.397
-11-42805.3
-55-1013763.197
-66-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

4 Replies
anbu1984
Master III
Master III

Can you post sample app

fkeuroglian
Partner
Partner

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

Fernando

rubenmarin

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.

Not applicable
Author

COMP_CODECS_COMP_CODECLM_COMP_CODECOMP_NAMELYTD ClaimsComments
423423689Total Value
111XYZ Company130105870.7  + 42805.3  last but 3rd row should be added here with codes 1,1,1 in the first 3 columns
166XYZ Company758898.667This row should not be there (duplicate)
222XYZ Company, Dubai248525030.4No change
333XYZ Company, Abu Dhabi36960129.95No change
555XYZ Insurance Company943114.697 + 1013763.197  last but 2nd row should be added here
666XYZ Company3990743.397 +  1842231.443   No change