Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

different wildmatch all in one

hiii community

this below are my 4 condition in 4 different sheets now i want all to get together in one sheet

so how can i get it

can anyone help me in this

=count(aggr(Count({<ICD_CODE_LEVEL1_org={'T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3',

'S42.2','S42.1','S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4',

'S32.3','S32.2','S32.1','S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6',

'S02.5','S02.4','S02.3','S02.2','S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1','S44.0','S82.7',

'S82.6','S82.5','S82.4','S82.3','S82.2','S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1','S22.9','S54.9','S54.8',

'S54.7','S54.2','S54.1','S54.0','S53.1','S53.0','S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1','S73.0','S72.9','S72.8','S72.7',

'S72.4','S72.3','S72.2','S72.1','S33.2','S33.1','S22.1','S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1','M84.0','M20.1','M67.4','M54.5','M54.3',

'M01.1*','M01.0*','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1','M51.0','M46.2','M49.0*','M23.0','M25.7','M25.6','M25.4','M90.0*','M89.3','M25.1','M25.0','M24.6','M24.5',

'M24.4','M24.0','M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3','M86.2','M86.1','M86.0','M85.6','M85.5','M85.4','M22.2','M22.1','M22.0','M21.6','M21.5','M21.4',

'M21.3','M21.2','M21.1','M21.0'},CLM_LEVEL_OF_CARE={'Secondary'}

,CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}

>}

ICD_CODE_LEVEL1_org),HOSPITAL_NAME,HOSPITAL_CODE,CLM_XGEN_CLAIM_NUM,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

=count(aggr(Count({<ICD_CODE_LEVEL1_org={'Z51.1','Y84.2','Y84.1','Y84.0','Y83.9','Z40.9','Z40.8','Z40.0','S83.6','S83.5','S83.4','S83.3','S83.2','S83.1','S83.0','D06.0','D05.9',

'D05.7','D05.1','D05.0','D04.9','D04.8','D04.7','D04.6','D04.5','D04.4','D04.3','D04.2','D04.1','D04.0','D03.9','D03.8','D03.7','D03.6','D03.5','D03.4','D03.3','D03.2','D03.1',

'D03.0','D02.4','D02.3','D02.2','D02.1','D02.0','R90.0','R58','A06.6','A06.5','A06.4','D17.6','D17.5','D17.4','D17.3','D17.2','D17.1','D17.0','D16.9','D16.8','D16.7','D16.6',

'D16.5','D16.4','D16.3','D16.2','D16.1','D16.0','D15.9','D15.7','D15.2','D15.1','D15.0','D11.7','D11.0','D10.9','D10.7','D10.6','D10.5','D10.4','D10.3','D10.2','G07*','L84','L88',

'D24','D27','D10.1','D10.0','D09.9','T90.5','B77.0','D09.7','D09.3','D09.2','D09.1','D09.0','D07.6','D07.5','D07.4','D07.3','D07.2','D07.1','D07.0','D06.9','D06.7','D06.1',

'S06.6','S06.5','D01.9','D01.7','D01.5','D01.4','D01.3','D01.2','D01.1','D01.0','D00.2','D00.1','D00.0','D14.4','D14.3','D14.2','D14.1','D14.0','D13.9','D13.7','D13.6','D13.5',

'D13.4','D13.3','D13.2','D13.1','D13.0','D12.9','D12.8','R02','S06.4','D12.7','D12.6','D12.5','D12.4','D12.3','D12.2','D12.1','D12.0','D11.9','A48.0','N13.9','N13.8','N13.7',

'N13.6','N13.5','N13.4','N13.3','N13.2','N13.1','N13.0','N11.1','Q43.6','Q79.3','Q79.1','Q40.1','Q40.0','J36','R22.0','R19.3','R19.2','R19.0','Q37.5','Q37.4','Q37.3','Q37.2',

'Q37.1','N43.4','N43.3','N43.2','N43.1','N43.0','N42.3','N42.1','N42.0','N41.9','N41.8','N41.2','N32.3','N32.2','N32.1','O02.0','O01.9','O01.1','Q18.1','Q18.0','N44','N47',

'N40','N26','H71','O01.0','Q39.6','Q64.3','Q64.2','Q64.1','Q64.0','Q37.0','Q36.9','Q36.1','Q36.0','Q35.9','Q35.7','Q35.5','Q35.3','Q35.1','O83.4','O82.2','O82.1','O82.0',

'O00.9','O00.8','O00.2','N15.1','Q61.2','Q61.1','Q61.0','K37','K36','N63','Q43.0','Q39.3','Q39.2','Q39.1','R10.0','N36.2','N36.1','N36.0','N35.9','N35.8','N35.1','N35.0',

'O71.4','O71.3','O71.2','O71.1','N28.1','O66.4','O66.3','O66.2','O66.1','O66.0','O65.9','O65.8','O65.5','O65.4','N99.4','N99.3','N99.2','D34','Q03.9','Q38.1','Q38.0','Q37.9',

'Q37.8','Q62.6','Q62.5','Q62.4','Q62.3','Q62.1','Q61.9','Q61.8','Q61.5','Q61.4','Q61.3','Q54.9','Q54.8','Q54.4','Q54.3','Q54.2','Q54.1','Q54.0','Q53.9','Q53.2','Q53.1','N34.0',

'N32.4','N22.8*','N22.0*','N21.9','N21.8','N21.1','N21.0','N20.9','N20.2','N20.1','N20.0','N88.2','N88.1','N88.0','N87.9','N87.2','N87.1','N87.0','N85.7','N85.6','N85.5','O43.2',

'N90.7','N90.4','N89.7','N89.5','N89.4','N89.3','N89.2','N85.3','N85.2','N85.1','N85.0','N84.9','N84.8','N84.3','N84.2','N84.1','N84.0','N83.7','N83.6','N83.5','N83.4','N83.3',

'N83.2','N75.1','N75.0','N83.1','N83.0','N82.9','N82.8','N82.5','N82.4','N82.3','N82.2','N82.1','N82.0','N81.9','N81.8','N81.6','N81.5','N81.4','N81.3','N81.2','N81.1','N81.0',

'J85.2','N80.4','N80.3','N80.2','N80.1','N80.0','N76.4','N70.9','N70.1','N70.0','N64.0','N60.9','N60.8','N60.4','N60.3','N60.2','N60.1','N60.0','O87.2','O22.4','K40.9','K40.4',

'K40.3','K40.2','K40.1','K40.0','K38.9','N48.1','N48.0','K38.8','K38.3','K38.2','K38.1','K38.0','K35.8','K35.3','K35.2','K31.7','K31.6','K31.5','K31.4','K31.2','K31.1','K25.6',

'K25.5','K25.3','K25.2','K25.1','K22.6','K22.5','K22.3','K22.2','K22.0','K28.6','K28.5','K28.2','K28.1','K27.6','K27.5','K27.3','K27.2','K27.1','K26.6','K26.5','K26.2','K26.1',

'L05.9','L05.0','K12.2','L98.0','K91.3','K91.2','K91.1','K83.9','K83.8','K83.5','K83.4','K83.3','K83.2','K83.1','K91.4','K11.6','K11.4','K11.3','M62.4','K82.3','K82.2','K82.1',

'K82.0','K81.9','K81.8','K66.1','K63.5','J94.2','J94.1','J94.0','J93.9','J93.8','J93.1','J93.0','J86.9','J86.0','J85.3','L89.9','L89.3','L89.2','K81.1','K81.0','K80.8','K80.5',

'K80.4','K80.3','K80.2','K80.1','K80.0','K63.3','K63.2','K63.1','K63.0','K62.9','K62.6','K62.5','K62.4','K62.3','K62.2','K62.1','K62.0','K61.4','K61.3','K61.2','K61.1','K61.0',

'K60.5','K60.4','K60.3','K60.2','K60.1','K56.4','K56.3','K56.2','K56.1','K56.0','K55.9','K55.1','K55.0','K60.0','K57.9','K57.8','K57.5','K57.4','K57.3','K57.2','K57.1','K57.0',

'K56.7','K56.6','K56.5','K46.9','K46.1','K46.0','K45.8','K45.1','K45.0','K44.9','K44.1','K44.0','K43.9','K43.1','K43.0','K42.9','K42.1','K42.0','K41.9','K41.4','K41.3','K41.2',

'K41.1','K41.0','J85.1','I77.0','I73.1','J39.1','J39.0','J38.1','J35.9','J35.8','J35.3','J35.2','J35.1','J35.0','J34.3','J34.2','J34.1','J34.0','J33.9','J33.8','J33.0','J32.9',

'J32.8','J32.4','J32.3','J32.2','J32.1','I97.2','I85.0','I84.9','I84.8','I84.7','I84.6','I84.5','I84.4','I84.3','I84.2','I84.1','I84.0','I31.3','I31.2','I67.1','I62.1','H95.0',

'I62.0','I61.1','H81.0','H80.9','H80.8','H80.2','H80.1','H80.0','H75.0*','H45.1*','H44.7','H44.6','H44.1','H44.0','H40.9','H40.8','H40.5','H40.4','H40.3','H40.2','H36.0*','H35.1',

'H70.9','H70.8','H70.2','H70.1','H70.0','H66.4','H66.3','H66.2','H66.1','H66.0','H65.9','H65.4','H65.3','H65.2','H61.2','H74.4','H74.2','H74.0','H60.4','H60.0','H06.0*','H05.5',

'H04.9','H04.8','H04.6','H04.5','H04.4','H04.3','H04.2','H04.1','H04.0','H02.1','H02.0','H01.0','H00.1','H00.0','G95.2','H30.2','H28.2*','H28.1*','H28.0*','H27.9','H27.8','H27.1',

'H27.0','H26.9','H26.8','H26.4','G57.6','G56.3','G56.2','G56.1','G56.0','H26.0','H25.9','H25.8','H25.2','H25.1','H25.0','H21.5','H11.0','H26.2','H26.1','D73.5','D29.9','D40.9',

'D21.5','D21.4','D21.3','D21.2','D21.1','D21.0','D20.1','D20.0','D19.9','D19.7','D19.1','D19.0','D18.1','D18.0','D17.9','D17.7','D37.3','D36.9','D36.7','D36.1','D36.0','D35.9',

'D35.8','D35.7','D35.6','D35.5','D35.4','D35.3','D35.2','D35.1','D35.0','D33.9','D33.7','D33.4','D33.3','D33.2','D33.1','D33.0','D32.9','D32.1','D32.0','D31.9','D31.6','D31.5',

'D31.4','D31.3','D31.2','D31.1','D31.0','D30.9','D30.7','D30.4','D30.3','D30.2','D30.1','D30.0','D29.7','D29.4','D29.3','D29.2','D29.1','D29.0','D28.9','D28.7','D28.2','D28.1',

'D28.0','D26.9','D26.7','D26.1','D26.0','D25.9','D25.2','D25.1','D25.0','D23.9','D23.7','D23.6','D23.5','D23.4','D23.3','D23.2','D23.1','D23.0','D22.9','D22.7','D22.6','D22.5',

'D22.4','D22.3','D22.2','D22.1','D22.0','D21.9','D21.6'},CLM_LEVEL_OF_CARE={'Secondary'}

,CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}

>}

ICD_CODE_LEVEL1_org),HOSPITAL_NAME,HOSPITAL_CODE,CLM_XGEN_CLAIM_NUM,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

=count(aggr(Count({<ICD_CODE_LEVEL1_org={'Y84.3','Z83.5','Z83.4','Z83.3','Z83.2','Z83.1','Z83.0','Z82.8','Z82.7','Z82.6','Z82.5','Z51.3','Z51.2','T78.1','T78.0','T09.3','T06.5',

'T67.9','T67.8','T67.7','T67.6','T67.5','T67.4','T67.3','T67.2','T67.1','T67.0','U04.9','T78.4','T78.2','A87.9','A87.8','A87.2','A87.1','A87.0','A85.1','A85.0','R55','B16.2',

'B16.1','B16.0','B15.9','B15.0','A17.1','A17.0','B02.1','B02.0','B01.2','B01.1','B01.0','B00.5','B00.4','B00.3','A98.8','A98.5','A06.3','A06.0','A05.9','A05.8','A05.4','A05.3',

'A05.2','A05.1','A05.0','A04.9','R53','R51','B53.8','B53.0','B52.9','B52.8','B52.0','B51.9','B51.8','B51.0','B50.9','B50.8','B50.0','R18','R17','R36','R35','R34','R33','R32',

'R31','R42','G35','G01*','A71.9','P90','T88.9','B77.8','S06.9','S06.8','S06.7','A83.0','A82.9','A82.1','A82.0','A80.9','E15','A71.1','B05.3','B05.2','B05.1','B05.0','B02.8',

'B02.7','B02.3','B02.2','A15.4','A15.3','A15.2','A15.1','A15.0','A09.9','A07.1','A04.4','A04.3','A04.2','A04.1','A04.0','A03.3','A03.2','A03.1','A03.0','A02.9','B20.1','B20.0',

'B19.9','A20.7','A20.3','A20.2','A20.1','A20.0','A18.1','A17.9','A17.8','R13','R12','R11','N10','S06.3','S06.2','S06.1','B19.0','B17.9','B17.8','B17.2','B17.1','A02.1','A02.0',

'A01.4','A01.3','A01.2','A01.1','A01.0','A00.9','A00.1','A00.0','T31.8','T31.7','T31.6','T31.5','T31.4','T31.3','T31.2','T31.1','T31.0','B16.9','D65','R96.1','T88.6','B69.0',

'A54.2','A54.1','A54.0','O85','A42.7','A41.9','A41.8','A41.5','A41.4','A41.3','A41.2','A41.1','A41.0','A40.9','J47','J46','G26*','R19.1','R07.4','R07.3','R07.2','R07.1','R06.8',

'R06.5','R06.4','R06.3','R06.2','R06.1','R06.0','R82.4','R82.3','R82.2','R82.1','R82.0','R27.0','R26.8','R26.2','R26.1','R26.0','O14.2','O14.1','O14.0','O12.2','O12.1','O12.0',

'N45.0','N41.0','P36.4','R73.9','O40','B54','B49','A99','B24','A91','A90','A89','A86','L00','J91*','J90','J81','J80','N19','I38','I00','I10','A35','A34','A33','A38','R59.0',

'R57.9','R57.8','R57.2','R57.1','R57.0','R56.8','R56.0','R52.1','R52.0','R50.9','R50.8','R50.2','R45.1','R40.2','R39.8','R39.2','R39.1','R39.0','R30.9','B26.1','B26.0','P74.3',

'P74.2','P74.1','P91.0','P36.3','P36.2','P36.1','P36.0','N30.0','N18.3','N18.2','N18.1','N17.9','N17.8','N17.2','N17.1','N17.0','P14.3','P59.0','A48.3','A37.1','A37.0','A36.0',

'T68','T71','J22','J14','J13','I48','I64','R68.0','R65.9','R65.3','R65.2','R65.1','R65.0','R16.2','R10.4','R10.3','R10.2','R10.1','R09.8','R09.2','R09.0','P61.0','P59.9','P59.8',

'P59.3','P59.2','R03.1','R03.0','R01.2','R01.1','R01.0','R00.8','R00.2','R00.1','R00.0','O72.2','O72.1','O05.8','O05.7','O05.6','O05.5','O05.4','O05.3','O05.2','O05.1','O05.0',

'O04.9','O04.8','O04.7','O04.6','O04.5','O04.4','O04.3','O04.2','O04.1','O04.0','N28.0','P14.1','P14.0','B38.1','B38.0','B37.7','B37.6','B37.5','A40.3','A40.2','A40.1','A40.0',

'A39.9','A39.8','A39.5','A39.4','A39.3','A39.2','A39.1','A39.0','S14.3','B26.9','B26.8','B26.3','B26.2','A31.0','R63.1','R63.0','R60.9','R60.1','P91.6','P78.3','P78.1','O15.1',

'O15.0','P28.9','P28.8','P28.5','N18.9','N18.5','N18.4','P23.9','P23.8','P23.6','P23.5','P23.4','P23.3','P23.2','P23.1','P23.0','P22.9','P22.8','P22.1','P22.0','P21.9','P21.1',

'P21.0','O46.9','O46.8','O46.0','N05.9','N05.8','N05.7','N05.6','N05.5','N05.4','N05.3','N03.8','N03.7','N03.6','N03.5','N03.4','N03.3','N03.2','N03.1','N03.0','O41.0','N02.9',

'N02.8','N02.7','N02.6','N02.5','N02.4','N02.3','N02.2','N02.1','N02.0','N01.9','N01.8','N01.7','N01.6','N01.5','N01.4','N01.3','N01.2','N01.1','O45.9','O45.8','O45.0','O44.1',

'O42.9','O42.2','O42.1','O42.0','N05.1','N05.0','N04.9','N04.8','N04.7','N04.6','N04.5','N04.4','N04.3','N04.2','N04.1','N04.0','N01.0','N00.9','N00.8','N00.7','O98.7','O98.4',

'N73.6','N73.5','N73.4','N73.3','N00.6','N00.5','N00.4','N00.3','N00.2','N00.1','N00.0','P01.3','P01.2','P01.1','N71.1','N71.0','P36.9','P36.8','P36.5','O88.8','O88.3','O88.1',

'O88.0','O86.8','O86.4','O86.3','O86.2','O86.1','O86.0','O21.1','O20.9','O20.8','O20.0','O15.9','O15.2','O24.9','O24.4','O24.3','O24.1','O24.0','N45.9','K25.4','K25.0','K23.0*',

'K22.7','K22.4','K22.1','K28.9','K28.7','K28.4','K28.3','K28.0','K27.9','K27.7','K27.4','K27.0','K26.9','K26.7','K26.4','K26.3','K26.0','K87.1*','K87.0*','K86.9','K86.8','K86.3',

'K86.2','K86.1','K86.0','K85.9','K85.8','K85.3','K85.2','K85.1','K85.0','K93.0*','K92.9','K92.8','K92.2','K92.1','K92.0','J96.9','J96.1','J96.0','K67.3*','K67.2*','K67.1*','K67.0*',

'K66.0','K65.9','K65.8','K65.0','K76.9','K76.8','K76.7','K76.6','K76.5','K76.4','K76.2','K76.1','K75.8','K75.4','K75.0','K74.6','K74.5','K74.4','K74.3','K73.9','K73.8','K73.2',

'K73.1','K73.0','K72.9','K72.1','K72.0','K71.9','K71.8','K71.7','K71.6','K71.5','K71.4','J98.3','J98.2','M34.9','M34.8','M34.0','M32.9','M32.8','M32.1','M25.5','K55.8','K52.3',

'K52.2','K52.1','K51.9','K51.8','K51.5','K51.4','K51.3','K51.2','K51.0','K50.9','M30.3','K50.8','K50.1','K50.0','J12.0','J11.8','J11.1','J11.0','J10.8','J10.1','J10.0','J06.9',

'J06.8','J06.0','J05.1','J05.0','J04.2','J04.1','J04.0','J03.9','J03.8','J84.9','J84.8','J84.1','J70.4','J70.3','J70.2','L53.0','L51.2','J66.0','J63.8','J63.5','J63.4','J63.3',

'J63.2','J63.1','J63.0','J62.8','J62.0','J45.9','J45.8','J45.1','J45.0','J44.9','J44.8','J44.1','J44.0','J43.9','J43.8','J43.2','J43.1','J41.8','J41.1','J41.0','J39.3','J37.1',

'J37.0','J30.0','J21.9','J21.8','J21.1','J21.0','J20.9','J20.8','J20.7','J20.6','J20.5','J20.4','J20.3','J20.2','J20.1','J20.0','J18.1','J18.0','J17.8*','J17.3*','J17.2*','J17.1*',

'J17.0*','J16.8','J16.0','J15.9','J15.8','J15.7','J15.6','J15.5','J15.4','J15.3','J15.2','J15.1','J15.0','J12.9','J12.8','J12.3','J12.2','J12.1','I69.1','J03.0','J02.9','J02.8',

'J02.0','J01.9','J01.8','J01.4','J01.3','J01.2','J01.1','J01.0','I85.9','I42.8','I42.5','I42.2','I42.1','I42.0','I40.9','I40.8','I40.1','I40.0','I37.9','I37.8','I37.2','I37.1',

'I36.8','I36.2','I36.1','I35.8','I35.2','I35.1','I35.0','I34.9','I34.8','I34.2','I34.1','I34.0','I33.9','I33.0','I31.1','I31.0','I30.9','I30.8','I30.1','I30.0','I69.0','I67.9',

'I67.8','I67.4','I63.9','I63.8','I63.6','I63.5','I63.4','I63.3','I63.2','I63.1','I63.0','I62.9','I01.9','I01.8','I01.2','I01.1','I01.0','I61.9','I61.8','I61.6','I61.5','I61.4',

'I61.3','I61.2','I61.0','I60.9','I60.8','I60.7','I60.6','I60.5','I60.4','I60.3','I60.2','I60.1','I60.0','I51.9','I51.8','I51.7','I51.6','I51.5','I51.4','I51.3','I51.0','I50.9',

'I50.1','I50.0','I49.9','I49.8','I49.5','I49.4','I49.3','I49.2','I49.1','I49.0','I47.9','I47.2','I47.1','I47.0','I46.9','I46.1','I46.0','I45.5','I44.7','I44.3','I44.2','I44.1',

'I44.0','I43.8*','H93.1','H92.2','H92.1','H92.0','H47.1','H45.0*','H43.9','H43.8','H43.3','H43.2','H43.1','H43.0','H42.8*','H42.0*','H40.6','H40.1','H40.0','H35.6','H35.5','H35.4',

'H35.3','H35.2','H34.1','H34.0','H33.5','H33.4','H33.3','H33.2','H33.1','H33.0','H32.8*','H32.0*','H73.0','H72.9','H72.8','H72.2','H72.1','H72.0','H67.8*','H67.1*','H67.0*','H66.9',

'H65.1','H65.0','H10.8','H10.5','H10.4','H10.3','H10.2','H10.1','H10.0','I27.9','I27.8','I27.2','I27.0','I26.9','I26.0','I25.9','I25.8','I25.6','I25.5','I25.4','I25.3','I25.2',

'I25.1','I25.0','I24.9','I24.8','I24.1','I24.0','I23.8','I23.2','I23.1','I22.9','I22.8','I22.1','I22.0','I21.9','I21.4','I21.3','I21.2','I21.1','I21.0','I20.9','I20.8','I20.1',

'I20.0','I15.2','I15.1','I15.0','I13.9','I13.2','I13.1','I13.0','I12.9','I12.0','I11.9','I11.0','I09.9','I09.8','I09.2','I09.1','I09.0','I08.0','I07.9','I07.8','I07.2','I07.1',

'I07.0','I06.9','I06.8','I06.2','I06.1','I06.0','I05.9','I05.8','I05.2','I05.1','I05.0','H60.8','H60.5','H60.3','H60.2','H60.1','H05.1','H05.0','G99.0*','G97.9','G97.2','G96.1',

'H31.1','H30.9','H30.8','G70.0','G63.2*','G61.0','G60.1','G59.0*','G56.4','G54.1','G54.0','G51.0','H22.8*','H22.1*','H22.0*','H21.9','H21.8','H21.3','H21.2','H21.1','H21.0','H20.9',

'H20.8','H20.2','H20.1','H20.0','H19.8*','H19.3*','H19.2*','H19.1*','H19.0*','H16.9','H16.8','H16.4','H16.3','H16.2','H16.1','H16.0','H15.9','H15.8','H15.1','H15.0','H13.2*',

'H13.1*','H13.0*','H11.9','H11.8','H11.4','H11.3','H10.9','G80.2','G80.1','G80.0','G94.2*','G94.1*','G93.7','G93.6','G93.5','G93.4','G83.9','G83.8','G83.4','G83.3','G83.2','G83.1',

'G83.0','G82.5','G82.4','G82.3','G82.2','G82.1','G82.0','G81.9','G81.1','G81.0','G12.2','G05.8*','G05.2*','G05.1*','G05.0*','G04.9','G04.8','G04.2','G04.1','G04.0','G03.9','G03.8',

'G03.2','G03.1','G03.0','G02.8*','G02.1*','G02.0*','G00.9','G00.8','G00.3','G00.2','G00.1','G00.0','G46.4*','G46.3*','G46.2*','G46.1*','G46.0*','G45.9','G45.8','G45.4','G45.3',

'G45.2','G45.1','G45.0','G43.3','G43.2','G41.9','G41.8','G41.2','G41.1','G41.0','G37.9','G37.8','G37.4','G37.3','G37.2','G37.1','G37.0','G36.9','G36.8','G36.1','G36.0','G32.8*',

'G31.9','G31.8','E14.9','E14.8','E14.7','E14.6','E14.5','E14.4','E14.3','E14.2','E14.1','E14.0','E13.9','E13.8','E13.7','E13.6','E13.5','E13.4','E87.8','E87.7','E87.6','E87.5',

'E87.4','E87.3','E87.2','E80.7','E13.3','E13.2','E13.1','E13.0','E11.9','E11.8','E11.7','E11.6','E11.5','E11.4','E11.3','E11.2','E11.1','E11.0','E10.9','E10.8','E10.7','E10.6',

'E10.5','E10.4','E10.3','E10.2','E10.1','E10.0','E03.5','D59.3','D56.2','D56.1','D73.2','E06.3','E06.0','E05.5','D50.0','D68.9','D68.8','D68.6','D68.5','D68.4','D68.3','D68.2',

'D68.1','D68.0','D64.9','D61.9','D61.8','D61.3','D61.2','D61.1','D61.0','D60.9','D60.8','D60.1','D59.9','D60.0'},CLM_LEVEL_OF_CARE={'Secondary'}

,CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}

>}

ICD_CODE_LEVEL1_org),HOSPITAL_NAME,HOSPITAL_CODE,CLM_XGEN_CLAIM_NUM,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

=count(aggr(Count({<ICD_CODE_LEVEL1_org={'Z51.1','Y84.2','Y84.1','Y84.0','Y83.9','Z40.9','Z40.8','Z40.0','S83.6','S83.5','S83.4','S83.3','S83.2','S83.1','S83.0','D06.0','D05.9',

'D05.7','D05.1','D05.0','D04.9','D04.8','D04.7','D04.6','D04.5','D04.4','D04.3','D04.2','D04.1','D04.0','D03.9','D03.8','D03.7','D03.6','D03.5','D03.4','D03.3','D03.2','D03.1',

'D03.0','D02.4','D02.3','D02.2','D02.1','D02.0','R90.0','R58','A06.6','A06.5','A06.4','D17.6','D17.5','D17.4','D17.3','D17.2','D17.1','D17.0','D16.9','D16.8','D16.7','D16.6',

'D16.5','D16.4','D16.3','D16.2','D16.1','D16.0','D15.9','D15.7','D15.2','D15.1','D15.0','D11.7','D11.0','D10.9','D10.7','D10.6','D10.5','D10.4','D10.3','D10.2','G07*','L84',

'L88','D24','D27','D10.1','D10.0','D09.9','T90.5','B77.0','D09.7','D09.3','D09.2','D09.1','D09.0','D07.6','D07.5','D07.4','D07.3','D07.2','D07.1','D07.0','D06.9','D06.7','D06.1',

'S06.6','S06.5','D01.9','D01.7','D01.5','D01.4','D01.3','D01.2','D01.1','D01.0','D00.2','D00.1','D00.0','D14.4','D14.3','D14.2','D14.1','D14.0','D13.9','D13.7','D13.6','D13.5',

'D13.4','D13.3','D13.2','D13.1','D13.0','D12.9','D12.8','R02','S06.4','D12.7','D12.6','D12.5','D12.4','D12.3','D12.2','D12.1','D12.0','D11.9','A48.0','N13.9','N13.8','N13.7',

'N13.6','N13.5','N13.4','N13.3','N13.2','N13.1','N13.0','N11.1','Q43.6','Q79.3','Q79.1','Q40.1','Q40.0','J36','R22.0','R19.3','R19.2','R19.0','Q37.5','Q37.4','Q37.3','Q37.2',

'Q37.1','N43.4','N43.3','N43.2','N43.1','N43.0','N42.3','N42.1','N42.0','N41.9','N41.8','N41.2','N32.3','N32.2','N32.1','O02.0','O01.9','O01.1','Q18.1','Q18.0','N44','N47','N40',

'N26','H71','O01.0','Q39.6','Q64.3','Q64.2','Q64.1','Q64.0','Q37.0','Q36.9','Q36.1','Q36.0','Q35.9','Q35.7','Q35.5','Q35.3','Q35.1','O83.4','O82.2','O82.1','O82.0','O00.9',

'O00.8','O00.2','N15.1','Q61.2','Q61.1','Q61.0','K37','K36','N63','Q43.0','Q39.3','Q39.2','Q39.1','R10.0','N36.2','N36.1','N36.0','N35.9','N35.8','N35.1','N35.0','O71.4','O71.3',

'O71.2','O71.1','N28.1','O66.4','O66.3','O66.2','O66.1','O66.0','O65.9','O65.8','O65.5','O65.4','N99.4','N99.3','N99.2','D34','Q03.9','Q38.1','Q38.0','Q37.9','Q37.8','Q62.6',

'Q62.5','Q62.4','Q62.3','Q62.1','Q61.9','Q61.8','Q61.5','Q61.4','Q61.3','Q54.9','Q54.8','Q54.4','Q54.3','Q54.2','Q54.1','Q54.0','Q53.9','Q53.2','Q53.1','N34.0','N32.4','N22.8*',

'N22.0*','N21.9','N21.8','N21.1','N21.0','N20.9','N20.2','N20.1','N20.0','N88.2','N88.1','N88.0','N87.9','N87.2','N87.1','N87.0','N85.7','N85.6','N85.5','O43.2','N90.7','N90.4',

'N89.7','N89.5','N89.4','N89.3','N89.2','N85.3','N85.2','N85.1','N85.0','N84.9','N84.8','N84.3','N84.2','N84.1','N84.0','N83.7','N83.6','N83.5','N83.4','N83.3','N83.2','N75.1',

'N75.0','N83.1','N83.0','N82.9','N82.8','N82.5','N82.4','N82.3','N82.2','N82.1','N82.0','N81.9','N81.8','N81.6','N81.5','N81.4','N81.3','N81.2','N81.1','N81.0','J85.2','N80.4',

'N80.3','N80.2','N80.1','N80.0','N76.4','N70.9','N70.1','N70.0','N64.0','N60.9','N60.8','N60.4','N60.3','N60.2','N60.1','N60.0','O87.2','O22.4','K40.9','K40.4','K40.3','K40.2',

'K40.1','K40.0','K38.9','N48.1','N48.0','K38.8','K38.3','K38.2','K38.1','K38.0','K35.8','K35.3','K35.2','K31.7','K31.6','K31.5','K31.4','K31.2','K31.1','K25.6','K25.5','K25.3',

'K25.2','K25.1','K22.6','K22.5','K22.3','K22.2','K22.0','K28.6','K28.5','K28.2','K28.1','K27.6','K27.5','K27.3','K27.2','K27.1','K26.6','K26.5','K26.2','K26.1','L05.9','L05.0',

'K12.2','L98.0','K91.3','K91.2','K91.1','K83.9','K83.8','K83.5','K83.4','K83.3','K83.2','K83.1','K91.4','K11.6','K11.4','K11.3','M62.4','K82.3','K82.2','K82.1','K82.0','K81.9',

'K81.8','K66.1','K63.5','J94.2','J94.1','J94.0','J93.9','J93.8','J93.1','J93.0','J86.9','J86.0','J85.3','L89.9','L89.3','L89.2','K81.1','K81.0','K80.8','K80.5','K80.4','K80.3',

'K80.2','K80.1','K80.0','K63.3','K63.2','K63.1','K63.0','K62.9','K62.6','K62.5','K62.4','K62.3','K62.2','K62.1','K62.0','K61.4','K61.3','K61.2','K61.1','K61.0','K60.5','K60.4',

'K60.3','K60.2','K60.1','K56.4','K56.3','K56.2','K56.1','K56.0','K55.9','K55.1','K55.0','K60.0','K57.9','K57.8','K57.5','K57.4','K57.3','K57.2','K57.1','K57.0','K56.7','K56.6',

'K56.5','K46.9','K46.1','K46.0','K45.8','K45.1','K45.0','K44.9','K44.1','K44.0','K43.9','K43.1','K43.0','K42.9','K42.1','K42.0','K41.9','K41.4','K41.3','K41.2','K41.1','K41.0',

'J85.1','I77.0','I73.1','J39.1','J39.0','J38.1','J35.9','J35.8','J35.3','J35.2','J35.1','J35.0','J34.3','J34.2','J34.1','J34.0','J33.9','J33.8','J33.0','J32.9','J32.8','J32.4',

'J32.3','J32.2','J32.1','I97.2','I85.0','I84.9','I84.8','I84.7','I84.6','I84.5','I84.4','I84.3','I84.2','I84.1','I84.0','I31.3','I31.2','I67.1','I62.1','H95.0','I62.0','I61.1',

'H81.0','H80.9','H80.8','H80.2','H80.1','H80.0','H75.0*','H45.1*','H44.7','H44.6','H44.1','H44.0','H40.9','H40.8','H40.5','H40.4','H40.3','H40.2','H36.0*','H35.1','H70.9','H70.8',

'H70.2','H70.1','H70.0','H66.4','H66.3','H66.2','H66.1','H66.0','H65.9','H65.4','H65.3','H65.2','H61.2','H74.4','H74.2','H74.0','H60.4','H60.0','H06.0*','H05.5','H04.9','H04.8',

'H04.6','H04.5','H04.4','H04.3','H04.2','H04.1','H04.0','H02.1','H02.0','H01.0','H00.1','H00.0','G95.2','H30.2','H28.2*','H28.1*','H28.0*','H27.9','H27.8','H27.1','H27.0','H26.9',

'H26.8','H26.4','G57.6','G56.3','G56.2','G56.1','G56.0','H26.0','H25.9','H25.8','H25.2','H25.1','H25.0','H21.5','H11.0','H26.2','H26.1','D73.5','D29.9','D40.9','D21.5','D21.4',

'D21.3','D21.2','D21.1','D21.0','D20.1','D20.0','D19.9','D19.7','D19.1','D19.0','D18.1','D18.0','D17.9','D17.7','D37.3','D36.9','D36.7','D36.1','D36.0','D35.9','D35.8','D35.7',

'D35.6','D35.5','D35.4','D35.3','D35.2','D35.1','D35.0','D33.9','D33.7','D33.4','D33.3','D33.2','D33.1','D33.0','D32.9','D32.1','D32.0','D31.9','D31.6','D31.5','D31.4','D31.3',

'D31.2','D31.1','D31.0','D30.9','D30.7','D30.4','D30.3','D30.2','D30.1','D30.0','D29.7','D29.4','D29.3','D29.2','D29.1','D29.0','D28.9','D28.7','D28.2','D28.1','D28.0','D26.9',

'D26.7','D26.1','D26.0','D25.9','D25.2','D25.1','D25.0','D23.9','D23.7','D23.6','D23.5','D23.4','D23.3','D23.2','D23.1','D23.0','D22.9','D22.7','D22.6','D22.5','D22.4','D22.3',

'D22.2','D22.1','D22.0','D21.9','D21.6','T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3','S42.2',

'S42.1','S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4','S32.3',

'S32.2','S32.1','S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6','S02.5',

'S02.4','S02.3','S02.2','S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1','S44.0','S82.7','S82.6',

'S82.5','S82.4','S82.3','S82.2','S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1','S22.9','S54.9','S54.8','S54.7',

'S54.2','S54.1','S54.0','S53.1','S53.0','S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1','S73.0','S72.9','S72.8','S72.7','S72.4',

'S72.3','S72.2','S72.1','S33.2','S33.1','S22.1','S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1','M84.0','M20.1','M67.4','M54.5','M54.3','M01.1*',

'M01.0*','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1','M51.0','M46.2','M49.0*','M23.0','M25.7','M25.6','M25.4','M90.0*','M89.3','M25.1','M25.0','M24.6','M24.5','M24.4','M24.0',

'M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3','M86.2','M86.1','M86.0','M85.6','M85.5','M85.4','M22.2','M22.1','M22.0','M21.6','M21.5','M21.4','M21.3','M21.2',

'M21.1','M21.0','Y84.3','Z83.5','Z83.4','Z83.3','Z83.2','Z83.1','Z83.0','Z82.8','Z82.7','Z82.6','Z82.5','Z51.3','Z51.2','T78.1','T78.0','T09.3','T06.5','T67.9','T67.8','T67.7',

'T67.6','T67.5','T67.4','T67.3','T67.2','T67.1','T67.0','U04.9','T78.4','T78.2','A87.9','A87.8','A87.2','A87.1','A87.0','A85.1','A85.0','R55','B16.2','B16.1','B16.0','B15.9',

'B15.0','A17.1','A17.0','B02.1','B02.0','B01.2','B01.1','B01.0','B00.5','B00.4','B00.3','A98.8','A98.5','A06.3','A06.0','A05.9','A05.8','A05.4','A05.3','A05.2','A05.1','A05.0',

'A04.9','R53','R51','B53.8','B53.0','B52.9','B52.8','B52.0','B51.9','B51.8','B51.0','B50.9','B50.8','B50.0','R18','R17','R36','R35','R34','R33','R32','R31','R42','G35','G01*',

'A71.9','P90','T88.9','B77.8','S06.9','S06.8','S06.7','A83.0','A82.9','A82.1','A82.0','A80.9','E15','A71.1','B05.3','B05.2','B05.1','B05.0','B02.8','B02.7','B02.3','B02.2',

'A15.4','A15.3','A15.2','A15.1','A15.0','A09.9','A07.1','A04.4','A04.3','A04.2','A04.1','A04.0','A03.3','A03.2','A03.1','A03.0','A02.9','B20.1','B20.0','B19.9','A20.7','A20.3',

'A20.2','A20.1','A20.0','A18.1','A17.9','A17.8','R13','R12','R11','N10','S06.3','S06.2','S06.1','B19.0','B17.9','B17.8','B17.2','B17.1','A02.1','A02.0','A01.4','A01.3','A01.2',

'A01.1','A01.0','A00.9','A00.1','A00.0','T31.8','T31.7','T31.6','T31.5','T31.4','T31.3','T31.2','T31.1','T31.0','B16.9','D65','R96.1','T88.6','B69.0','A54.2','A54.1','A54.0',

'O85','A42.7','A41.9','A41.8','A41.5','A41.4','A41.3','A41.2','A41.1','A41.0','A40.9','J47','J46','G26*','R19.1','R07.4','R07.3','R07.2','R07.1','R06.8','R06.5','R06.4','R06.3',

'R06.2','R06.1','R06.0','R82.4','R82.3','R82.2','R82.1','R82.0','R27.0','R26.8','R26.2','R26.1','R26.0','O14.2','O14.1','O14.0','O12.2','O12.1','O12.0','N45.0','N41.0','P36.4',

'R73.9','O40','B54','B49','A99','B24','A91','A90','A89','A86','L00','J91*','J90','J81','J80','N19','I38','I00','I10','A35','A34','A33','A38','R59.0','R57.9','R57.8','R57.2',

'R57.1','R57.0','R56.8','R56.0','R52.1','R52.0','R50.9','R50.8','R50.2','R45.1','R40.2','R39.8','R39.2','R39.1','R39.0','R30.9','B26.1','B26.0','P74.3','P74.2','P74.1','P91.0',

'P36.3','P36.2','P36.1','P36.0','N30.0','N18.3','N18.2','N18.1','N17.9','N17.8','N17.2','N17.1','N17.0','P14.3','P59.0','A48.3','A37.1','A37.0','A36.0','T68','T71','J22','J14',

'J13','I48','I64','R68.0','R65.9','R65.3','R65.2','R65.1','R65.0','R16.2','R10.4','R10.3','R10.2','R10.1','R09.8','R09.2','R09.0','P61.0','P59.9','P59.8','P59.3','P59.2','R03.1',

'R03.0','R01.2','R01.1','R01.0','R00.8','R00.2','R00.1','R00.0','O72.2','O72.1','O05.8','O05.7','O05.6','O05.5','O05.4','O05.3','O05.2','O05.1','O05.0','O04.9','O04.8','O04.7',

'O04.6','O04.5','O04.4','O04.3','O04.2','O04.1','O04.0','N28.0','P14.1','P14.0','B38.1','B38.0','B37.7','B37.6','B37.5','A40.3','A40.2','A40.1','A40.0','A39.9','A39.8','A39.5',

'A39.4','A39.3','A39.2','A39.1','A39.0','S14.3','B26.9','B26.8','B26.3','B26.2','A31.0','R63.1','R63.0','R60.9','R60.1','P91.6','P78.3','P78.1','O15.1','O15.0','P28.9','P28.8',

'P28.5','N18.9','N18.5','N18.4','P23.9','P23.8','P23.6','P23.5','P23.4','P23.3','P23.2','P23.1','P23.0','P22.9','P22.8','P22.1','P22.0','P21.9','P21.1','P21.0','O46.9','O46.8',

'O46.0','N05.9','N05.8','N05.7','N05.6','N05.5','N05.4','N05.3','N03.8','N03.7','N03.6','N03.5','N03.4','N03.3','N03.2','N03.1','N03.0','O41.0','N02.9','N02.8','N02.7','N02.6',

'N02.5','N02.4','N02.3','N02.2','N02.1','N02.0','N01.9','N01.8','N01.7','N01.6','N01.5','N01.4','N01.3','N01.2','N01.1','O45.9','O45.8','O45.0','O44.1','O42.9','O42.2','O42.1',

'O42.0','N05.1','N05.0','N04.9','N04.8','N04.7','N04.6','N04.5','N04.4','N04.3','N04.2','N04.1','N04.0','N01.0','N00.9','N00.8','N00.7','O98.7','O98.4','N73.6','N73.5','N73.4',

'N73.3','N00.6','N00.5','N00.4','N00.3','N00.2','N00.1','N00.0','P01.3','P01.2','P01.1','N71.1','N71.0','P36.9','P36.8','P36.5','O88.8','O88.3','O88.1','O88.0','O86.8','O86.4',

'O86.3','O86.2','O86.1','O86.0','O21.1','O20.9','O20.8','O20.0','O15.9','O15.2','O24.9','O24.4','O24.3','O24.1','O24.0','N45.9','K25.4','K25.0','K23.0*','K22.7','K22.4','K22.1',

'K28.9','K28.7','K28.4','K28.3','K28.0','K27.9','K27.7','K27.4','K27.0','K26.9','K26.7','K26.4','K26.3','K26.0','K87.1*','K87.0*','K86.9','K86.8','K86.3','K86.2','K86.1','K86.0',

'K85.9','K85.8','K85.3','K85.2','K85.1','K85.0','K93.0*','K92.9','K92.8','K92.2','K92.1','K92.0','J96.9','J96.1','J96.0','K67.3*','K67.2*','K67.1*','K67.0*','K66.0','K65.9',

'K65.8','K65.0','K76.9','K76.8','K76.7','K76.6','K76.5','K76.4','K76.2','K76.1','K75.8','K75.4','K75.0','K74.6','K74.5','K74.4','K74.3','K73.9','K73.8','K73.2','K73.1','K73.0',

'K72.9','K72.1','K72.0','K71.9','K71.8','K71.7','K71.6','K71.5','K71.4','J98.3','J98.2','M34.9','M34.8','M34.0','M32.9','M32.8','M32.1','M25.5','K55.8','K52.3','K52.2','K52.1',

'K51.9','K51.8','K51.5','K51.4','K51.3','K51.2','K51.0','K50.9','M30.3','K50.8','K50.1','K50.0','J12.0','J11.8','J11.1','J11.0','J10.8','J10.1','J10.0','J06.9','J06.8','J06.0',

'J05.1','J05.0','J04.2','J04.1','J04.0','J03.9','J03.8','J84.9','J84.8','J84.1','J70.4','J70.3','J70.2','L53.0','L51.2','J66.0','J63.8','J63.5','J63.4','J63.3','J63.2','J63.1',

'J63.0','J62.8','J62.0','J45.9','J45.8','J45.1','J45.0','J44.9','J44.8','J44.1','J44.0','J43.9','J43.8','J43.2','J43.1','J41.8','J41.1','J41.0','J39.3','J37.1','J37.0','J30.0',

'J21.9','J21.8','J21.1','J21.0','J20.9','J20.8','J20.7','J20.6','J20.5','J20.4','J20.3','J20.2','J20.1','J20.0','J18.1','J18.0','J17.8*','J17.3*','J17.2*','J17.1*','J17.0*',

'J16.8','J16.0','J15.9','J15.8','J15.7','J15.6','J15.5','J15.4','J15.3','J15.2','J15.1','J15.0','J12.9','J12.8','J12.3','J12.2','J12.1','I69.1','J03.0','J02.9','J02.8','J02.0',

'J01.9','J01.8','J01.4','J01.3','J01.2','J01.1','J01.0','I85.9','I42.8','I42.5','I42.2','I42.1','I42.0','I40.9','I40.8','I40.1','I40.0','I37.9','I37.8','I37.2','I37.1','I36.8',

'I36.2','I36.1','I35.8','I35.2','I35.1','I35.0','I34.9','I34.8','I34.2','I34.1','I34.0','I33.9','I33.0','I31.1','I31.0','I30.9','I30.8','I30.1','I30.0','I69.0','I67.9','I67.8',

'I67.4','I63.9','I63.8','I63.6','I63.5','I63.4','I63.3','I63.2','I63.1','I63.0','I62.9','I01.9','I01.8','I01.2','I01.1','I01.0','I61.9','I61.8','I61.6','I61.5','I61.4','I61.3',

'I61.2','I61.0','I60.9','I60.8','I60.7','I60.6','I60.5','I60.4','I60.3','I60.2','I60.1','I60.0','I51.9','I51.8','I51.7','I51.6','I51.5','I51.4','I51.3','I51.0','I50.9','I50.1',

'I50.0','I49.9','I49.8','I49.5','I49.4','I49.3','I49.2','I49.1','I49.0','I47.9','I47.2','I47.1','I47.0','I46.9','I46.1','I46.0','I45.5','I44.7','I44.3','I44.2','I44.1','I44.0',

'I43.8*','H93.1','H92.2','H92.1','H92.0','H47.1','H45.0*','H43.9','H43.8','H43.3','H43.2','H43.1','H43.0','H42.8*','H42.0*','H40.6','H40.1','H40.0','H35.6','H35.5','H35.4','H35.3',

'H35.2','H34.1','H34.0','H33.5','H33.4','H33.3','H33.2','H33.1','H33.0','H32.8*','H32.0*','H73.0','H72.9','H72.8','H72.2','H72.1','H72.0','H67.8*','H67.1*','H67.0*','H66.9',

'H65.1','H65.0','H10.8','H10.5','H10.4','H10.3','H10.2','H10.1','H10.0','I27.9','I27.8','I27.2','I27.0','I26.9','I26.0','I25.9','I25.8','I25.6','I25.5','I25.4','I25.3','I25.2',

'I25.1','I25.0','I24.9','I24.8','I24.1','I24.0','I23.8','I23.2','I23.1','I22.9','I22.8','I22.1','I22.0','I21.9','I21.4','I21.3','I21.2','I21.1','I21.0','I20.9','I20.8','I20.1',

'I20.0','I15.2','I15.1','I15.0','I13.9','I13.2','I13.1','I13.0','I12.9','I12.0','I11.9','I11.0','I09.9','I09.8','I09.2','I09.1','I09.0','I08.0','I07.9','I07.8','I07.2','I07.1',

'I07.0','I06.9','I06.8','I06.2','I06.1','I06.0','I05.9','I05.8','I05.2','I05.1','I05.0','H60.8','H60.5','H60.3','H60.2','H60.1','H05.1','H05.0','G99.0*','G97.9','G97.2','G96.1',

'H31.1','H30.9','H30.8','G70.0','G63.2*','G61.0','G60.1','G59.0*','G56.4','G54.1','G54.0','G51.0','H22.8*','H22.1*','H22.0*','H21.9','H21.8','H21.3','H21.2','H21.1','H21.0',

'H20.9','H20.8','H20.2','H20.1','H20.0','H19.8*','H19.3*','H19.2*','H19.1*','H19.0*','H16.9','H16.8','H16.4','H16.3','H16.2','H16.1','H16.0','H15.9','H15.8','H15.1','H15.0',

'H13.2*','H13.1*','H13.0*','H11.9','H11.8','H11.4','H11.3','H10.9','G80.2','G80.1','G80.0','G94.2*','G94.1*','G93.7','G93.6','G93.5','G93.4','G83.9','G83.8','G83.4','G83.3',

'G83.2','G83.1','G83.0','G82.5','G82.4','G82.3','G82.2','G82.1','G82.0','G81.9','G81.1','G81.0','G12.2','G05.8*','G05.2*','G05.1*','G05.0*','G04.9','G04.8','G04.2','G04.1',

'G04.0','G03.9','G03.8','G03.2','G03.1','G03.0','G02.8*','G02.1*','G02.0*','G00.9','G00.8','G00.3','G00.2','G00.1','G00.0','G46.4*','G46.3*','G46.2*','G46.1*','G46.0*','G45.9',

'G45.8','G45.4','G45.3','G45.2','G45.1','G45.0','G43.3','G43.2','G41.9','G41.8','G41.2','G41.1','G41.0','G37.9','G37.8','G37.4','G37.3','G37.2','G37.1','G37.0','G36.9','G36.8',

'G36.1','G36.0','G32.8*','G31.9','G31.8','E14.9','E14.8','E14.7','E14.6','E14.5','E14.4','E14.3','E14.2','E14.1','E14.0','E13.9','E13.8','E13.7','E13.6','E13.5','E13.4','E87.8',

'E87.7','E87.6','E87.5','E87.4','E87.3','E87.2','E80.7','13.3','E13.2','E13.1','E13.0','E11.9','E11.8','E11.7','E11.6','E11.5','E11.4','E11.3','E11.2','E11.1','E11.0','E10.9',

'E10.8','E10.7','E10.6','E10.5','E10.4','E10.3','E10.2','E10.1','E10.0','E03.5','D59.3','D56.2','D56.1','D73.2','E06.3','E06.0','E05.5','D50.0','D68.9','D68.8','D68.6','D68.5',

'D68.4','D68.3','D68.2','D68.1','D68.0','D64.9','D61.9','D61.8','D61.3','D61.2','D61.1','D61.0','D60.9','D60.8','D60.1','D60.0','D59.9'},CLM_LEVEL_OF_CARE={'Secondary'}

,CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}

>}

ICD_CODE_LEVEL1_org),HOSPITAL_NAME,HOSPITAL_CODE,CLM_XGEN_CLAIM_NUM,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))

4 Replies
kumarkp412
Creator II
Creator II

Hi sagar,

Can you elaborate ypur question?

Thanks

kumar kvp

sagarrahul
Creator
Creator
Author

there are 4 different condition as i shown above

now i want it to run in one set .

before i was using 4 set of to run these 4 program but now want it in only one .

Gysbert_Wassenaar

Create a new field in the script for the four groups of ICD_CODE_LEVEL1_org values. Then use that group field instead of that enormous list of ICD_CODE_LEVEL1_org values in the set modifier.

Then explain what you're trying to calculate. It seems like a count of a the number combinations of OSPITAL_NAME, HOSPITAL_CODE, CLM_XGEN_CLAIM_NUM, CLM_INTIMATION_DATE and ICD_CODE_LEVEL1_org values that meet the criteria of the record set selector.


talk is cheap, supply exceeds demand
sagarrahul
Creator
Creator
Author

ty for ur reply

as i am new in this they have not given me right to develop anything new in this

so can u use if condition or wildmatch to sort this problem of mine