topic More than one statement to a field in QlikView

More than one statement to a field

Fri, 01 Jul 2016 10:10:49 GMT

I have the following data ( attached ).

I already have the following statement which says anything that begins with 9 should be assigned a region of unrestricted.

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region) as Region_New

What I now want to do as per the expected output in the spreadsheet is to say any region that begins Lon* should be replaced with London.

Please assist with applying the new logic to current one.

PrashantSangle — Fri, 01 Jul 2016 10:22:32 GMT

Hi,

You need nested if else

try like

if(wildmatch(Sales_Number,'9*'),'UnRestricted',

if(wildmatch(Region,'Lon*'),'London',

Region))

Regards

sushil353 — Fri, 01 Jul 2016 10:25:39 GMT

try this:

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region) or if(wildmatch(Region,'Lon*','London',Region) as Region_New

HTH

Fri, 01 Jul 2016 11:50:50 GMT

This is missing a bracket I believe (?)