topic Script help???? in QlikView

Script help????

amit_saini — Mon, 19 Oct 2015 10:04:33 GMT

Hi Folks,

Looking for below logic:

If Category 3 to be ends with %ECC_BEL then show Incident,

If Category 3 to be ends with %BEL_C then show Change,

If Category 3 is null or – then Category 2 = Unclassified

I'm trying something like below , but how to check this condition only at end .

For example in this case if Category 3 = OTHERS_MMPP_ECC_BEL_C then output should be Change , but with below expression I'm getting output this as Incident.

if(wildmatch(CAT_ID, '*ECC_BEL*'),'Incident',if(wildmatch(CAT_ID, '*BEL_C*'),'Change','Unclassified')) as Category2

Thanks,

Re: Script help????

tresB — Mon, 19 Oct 2015 10:11:20 GMT

Pick(wildmatch(CAT_ID, '*ECC_BEL','*BEL_C')+1,'Unclassified', 'Incident', 'Change') as Category2

Or just remove the last '*' from your expression comparison string like,

if(wildmatch(CAT_ID, '*ECC_BEL'),'Incident',if(wildmatch(CAT_ID, '*BEL_C'),'Change','Unclassified')) as Category2

Re: Script help????

Peter_Cammaert — Mon, 19 Oct 2015 10:25:43 GMT

And if you got some spare time, please read these:

QlikCommunity Tip: How to get answers to your p... | Qlik Community

Qlik Community Tip: Posting Successful Discussion Threads

You can make this discussion useful for other people as well by using a descriptive title and adding search tags.