Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sagarrahul
New Contributor III

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
MVP
MVP

Re: wildmatch

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])

Re: wildmatch

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
New Contributor III

Re: wildmatch

not working error msg  (Error in calculation)

Re: wildmatch

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

reddys310
Honored Contributor II

Re: wildmatch

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

reddys310
Honored Contributor II

Re: wildmatch

Also,

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

Check this out:

Wild match function usage in Qlikview scripting

MVP
MVP

Re: wildmatch

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