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

wildmatch

hiiiiiii

is this wild match script correct if not then help me in this .

=if(WildMatch([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'),'ICD_CODE_LEVEL1_org'))

7 Replies
sunny_talwar

May be this:

=if(WildMatch([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'),'ICD_CODE_LEVEL1_org')

Also not sure if the intention is to use static value for all these Codes or use the original value. Right now you have it as static value -> ICD_CODE_LEVEL1_org

May be you want this:

=if(WildMatch([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'),[ICD_CODE_LEVEL1_org])

marcus_sommer

An alternatively to such (large) match-function could be to categorize them on script-level per mapping: Mapping … and not the geographical kind and/or to flag it there.

- Marcus

sagarrahul
Creator
Creator
Author

not working error msg  (Error in calculation)

marcus_sommer

It's probably a small syntax issue with some missing comma or single-quote or similar and it's quite hard to develop and maintain such large expressions without problems like this. Therefore have a look on my answer below.

- Marcus

reddy-s
Master II
Master II

Hi Sagar,

I would really suggest you to work this out in the load script instead. Its good practice to keep your UI light and push most of the complex into the load script.

Thanks and Regards,

Sangram

reddy-s
Master II
Master II

Also,

Make use of the Wild match in your load script instead.

Check this out:

Wild match function usage in Qlikview scripting

sunny_talwar

I think I am going to agree big time with Marcus‌ here