topic Re: Wildmatch in QlikView

Wildmatch

Abhi999 — Wed, 25 Nov 2020 16:16:04 GMT

i am using below condition

if(match(ProductType,'OEIC','ISA') and WildMatch(Department,'FM*','Outsourced Provider – AIGSL*','REAL ASSETS*'),'OEIC FM')

there is match condition between PRODUCT=oeic AND dEPARTMENT='Outsourced Provider -AIGSL)

it is showing empty.

Re: Wildmatch

Qlik1_User1 — Mon, 16 Mar 2020 14:40:52 GMT

Might be some of the condition is not fulfilled, share the sample data

Re: Wildmatch

sunny_talwar — Mon, 16 Mar 2020 15:04:06 GMT

Do you have a space between - and AIGSL or not? You match expression includes a space, but the next row doesn't

Re: Wildmatch

Abhi999 — Mon, 16 Mar 2020 15:30:33 GMT

Department:
LOAD
DID,
Department,
if(IsThirdParty=-1,'Yes',if(IsThirdParty=0,'No','N/A')) as IsThirdParty,
OrderBy

FROM [lib://Mandate QVD Generator (avivagroup_avelamuri)/dataREDDepartment.qvd]
(qvd) where if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');

I am using above condition on table but it is showing all Departments whic didn't mentioned in condition also

Re: Wildmatch

sunny_talwar — Mon, 16 Mar 2020 15:51:27 GMT

This looks like a different question from the one your initially asked. Is the first issue resolved now?

Re: Wildmatch

Qlik1_User1 — Tue, 17 Mar 2020 06:33:08 GMT

You didn't mentioned where condition correctly it seems

You have used

where if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');

Try this

where enter dim name= if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');

Also as Sunny mentioned , please check if you are using correct field values without space..

Re: Wildmatch

Abhi999 — Fri, 01 May 2020 09:59:58 GMT

Thanks it worked for me

Re: Wildmatch

Qlik1_User1 — Mon, 11 May 2020 13:24:17 GMT

@Abhi999 please close the thread by marking accepted as a solution.