Wildmatch

[Abhi999]

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.

[Qlik1_User1]

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

[sunny_talwar]

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

[Abhi999]

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

[sunny_talwar]

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

[Qlik1_User1]

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

[Abhi999]

Thanks it worked for me

[Qlik1_User1]

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