topic like in qlikview in QlikView

like in qlikview

capriconuser — Tue, 17 Apr 2018 07:47:08 GMT

I have a data like this

knee join

knee pain

knee

knee JT

eye

eye pain

eye damage

eyelid retraction right eye

mouth

abdomen

dysprea

frontal

now i want to get like this ...

like when anywhere where knee word is found i want to name all these word with knee and when any word start from eye then want to name it eye

and except this all renaming i want to name it "other"

knee join	knee
kneepain	knee
Abrasion, left knee, initial encounter	knee
knee JT	knee
eye	eye
eye pain	eye
eye damage	eye
eyelid retraction right eye	eye
mouth	mouth
abdomen	other
dysprea	other
frontal	other

i tried this

If(WildMatch(col1,'*knee*'),'Kneee',If(WildMatch(col1,'*eye*'),'Eye'))

but this shows only 1 result with eye where as i have 3 records related to eye and knee record is not display..

Re: like in qlikview

jayshrinipurte — Tue, 17 Apr 2018 07:50:59 GMT

Dear Capricon,

WildMatch() function will help you.

If(WildMatch(Field_Name,'Knee*'),'Kneee',

If(WildMatch(Field_Name,'Eye*'),'Eye'))

Regards,

Jayshri

Re: like in qlikview

keerthika — Tue, 17 Apr 2018 07:55:25 GMT

Hi,

Try this one

if(WildMatch(name,'knee*'),'Knee',

if(WildMatch(name,'eye*'),'eye',

'other'))

Re: like in qlikview

capriconuser — Tue, 17 Apr 2018 08:03:25 GMT

what if

like i have a knee word where this is place in the end ,in between or anywhere position ..

like anywhere knee word is identified i want to name as "knee"

like this

knee join

joint knee break

break knee join 2

Abrasion, left knee, initial encounter

i want to name this all as "knee"

Re: like in qlikview

jayshrinipurte — Tue, 17 Apr 2018 08:04:50 GMT

If(WildMatch(Field_Name,'*Knee*'),'Kneee',

If(WildMatch(Field_Name,'*Eye*'),'Eye'),

'Others')

Re: like in qlikview

petter — Tue, 17 Apr 2018 08:05:42 GMT

As the other suggested you can use the WildMatch() function although it is not necessary to complicate it with multiple Wildmatch and If:

Pick(WildMatch(Lower(Bodypart),'knee*','eye*','mouth')+1,'other','knee','eye','mouth')

Re: like in qlikview

capriconuser — Tue, 17 Apr 2018 08:06:51 GMT

this expression did not work this shows an error on others

Re: like in qlikview

petter — Tue, 17 Apr 2018 08:07:51 GMT

You will have to use the wildcard pattern:

'*knee*' which will pick any sentence with the characters knee in it

Re: like in qlikview

jayshrinipurte — Tue, 17 Apr 2018 08:10:37 GMT

If(WildMatch(Field_Name,'*Knee*'),'Kneee',

If(WildMatch(Field_Name,'*Eye*'),'Eye',

'Others'))

Re: like in qlikview

capriconuser — Tue, 17 Apr 2018 09:23:45 GMT

this is not working i have several words where knee word word is exist but none of them is displayed

Re: like in qlikview

capriconuser — Tue, 17 Apr 2018 09:36:18 GMT

not working just this file

Re: like in qlikview

capriconuser — Tue, 17 Apr 2018 10:02:37 GMT

what is +1 here?

Re: like in qlikview

jayshrinipurte — Tue, 17 Apr 2018 10:08:56 GMT

Dear Capricorn,

Find the below attachment

Regards,

Jayshri

Re: like in qlikview

petter — Tue, 17 Apr 2018 10:23:22 GMT

The addition of one will make sure that if there is no match the 'other' is picked...

WildMatch(Lower(Bodypart),'knee*','eye*','mouth') will return 0 (if not match), 1 for 'knee*' 2 for 'eye*' 3 for 'mouth'

by adding 1 you can cater for no match too in the Pick function....