Looking for similar expression in qlik

[kiara]

I am looking for similar expression in Qlik. In sql I used the following:

INSTR(lowercase({drugname}),'A') > 0 OR
INSTR(lowercase({drugname}),'B') > 0 OR
INSTR(lowercase({drugname}),'C') > 0 OR
INSTR(lowercase({drugname}),'D') > 0 OR
INSTR(lowercase({drugname}),'E') > 0 OR
INSTR(lowercase({drugname}),'F) > 0 OR
INSTR(lowercase({drugname}),'G') > 0 OR
INSTR(lowercase({drugname}),'H') > 0 OR
INSTR(lowercase({drugname}),'I') > 0 

I tried mixmatch, wildcard functions .But did get the whole list of drugs. please help.

[sidhiq91]

@kiara  Could you please provide your exact requirement? Because we can replicate whatever you have written in SQL to Qlik. But to make it more effective we need to understand the requirement.

For Example your above SQL code can be converted in Qlikas below:

if(Index(Upper(Drugname),'A')>0,

[rwunderlich]

I would think this would work:

WildMatch(drugname, '*A', '*B*', '*C*',...)

I'm confused about the lowercase() function in your example. It seems to me that this converts drugname to lower case and would never match the upper case characters in your example.

-Rob