topic Re: Looking for similar expression in qlik in Reporting Service & Alerting

Looking for similar expression in qlik

kiara — Fri, 08 Jul 2022 19:34:01 GMT

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.

Re: Looking for similar expression in qlik

sidhiq91 — Sat, 09 Jul 2022 00:49:27 GMT

@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,

Re: Looking for similar expression in qlik

rwunderlich — Sat, 09 Jul 2022 13:47:36 GMT

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