Using WildCharacters to reduce selection

[asinghal0412]

Dear Qlik Community,

I have a code below:

=if(Status_VAVE ='VSG5 - Monitoring' or Status_VAVE = 'VSG5- Release for Production', Status_VAVE)

The code works but it is too long. I want to use wild characters to reduce the code, something like below:

=if(Status_VAVE ='VSG5*', Status_VAVE)

The above code does not work. Can someone help me with this?

Thanks,

AS

[MayilVahanan · Accepted solution]

HI @asinghal0412 

Try like below

=if(wildmatch(Status_VAVE ,'VSG5*'), Status_VAVE)