topic Re: Match Expr in QlikView

Match Expr

Fri, 17 Jul 2015 10:34:06 GMT

Hi Experts,

How to write the below expression, I have to show this(Error and Warning) in List box as a filter. I have tried with Wildmatch but its case insensitive so I am not able to get it.

I have Prodcut column Ex: Its just an example, In real I have millions of records

Product
Abc
ABC
cBc
CBc

KZX

kYS
]

I need to expression like below:

if PRODUCTS IN ('%b%', '%k%') as Error

if PRODUCTS IN ('%B%','%K%') as WARNING

Then my List box should show like

Exception(Filter name)

Error

Warning

So Error should be equal to - Abc and kYS

Warning should be equal to - ABC,cBc,CBc,KZX

I have tried like below as per Qlik Community but not working out

Pick(Wildmatch(Product,'*b*','*k*','*B*','*K*'),'Error','Error','WARNING','WARNING')

also the same in backend script like

Pick(Wildmatch(Product,'*b*','*k*','*B*','*K*'),'Error','Error','WARNING','WARNING') as flag

Re: Match Expr

Gysbert_Wassenaar — Fri, 17 Jul 2015 10:36:38 GMT

Please don't post duplicate questions: Match Expression

Re: Match Expr

jjordaan — Fri, 17 Jul 2015 10:37:34 GMT

You can use the Match function.

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

Example:

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan

It does the same as WildMatch only Match is case sensitive.

Hope this helps

Re: Match Expr

sasiparupudi1 — Fri, 17 Jul 2015 10:53:53 GMT

Please close this thread as you got your answer in the other thread already

Re: Match Expr

senpradip007 — Fri, 17 Jul 2015 11:04:01 GMT

Have a look on this.

Re: Match Expr

Fri, 17 Jul 2015 11:51:32 GMT

Hi Gysbert,

When I post this question, I didn't get answer for the old one...

Re: Match Expr

Fri, 17 Jul 2015 11:53:34 GMT

I am not able to delete this thread... it showing unauthorized access.. That is why I kept this thread

Re: Match Expr

sasiparupudi1 — Fri, 17 Jul 2015 12:06:55 GMT

Well then I suggest you close this thread by marking your reply as the correct answer.

Re: Match Expr

Gysbert_Wassenaar — Fri, 17 Jul 2015 12:17:29 GMT

First discussion posted: Jul 17, 2015 12:05 PM

Second discussion posted: Jul 17, 2015 12:34 PM

Conclusion: Your patience is limited to less than half an hour.

Your life must be a very frustrating experience to you. Not to mention to those that have to live or work with you.