topic Help Me Out in QlikView

Help Me Out

Fri, 15 May 2015 06:58:53 GMT

Hello,

I am trying to make a group of item code using wild match function with their respective item names.

Eg: if(wildmatch(Itemcode,'01*'),Itemname) as RawMaterial,

if(wildmatch(Itemcode,'02*'),Itemname) as Clothing,

if(wildmatch(Itemcode,'03*'),Itemname) as Fuel,

if(wildmatch(Itemcode,'04*'),Itemname) as Paper,

if(wildmatch(Itemcode,'05*'),Itemname) as Machine,

The problem where i am stuck is that I need to make an another group where every Item Name Starting with ItemCode '07*' till '99' need to come under a single group.

Note:The item Code is alpha-numeric.

I have tried it using the below code but not able to get it.

===> if(WildMatch(ItemCode >='07*' or ItemCode <='99'),Itemname) as STORES &Spares,

Please help me out.......!!!!!!!!!!!!!!

Re: Help Me Out

qlikviewwizard — Fri, 15 May 2015 08:54:40 GMT

Hi atulshishodia,

Try the below:

if(WildMatch(ItemCode >='07*' or ItemCode <='99'),Itemname) as [STORES &Spares],

Hope this will helps.

Re: Help Me Out

Gysbert_Wassenaar — Fri, 15 May 2015 08:54:51 GMT

Perhaps like this:

If( Num(Left(ItemCode,2)) >= 7 and Num(Left(ItemCode,2)) <= 99, Itemname) as STORES&Spares

Re: Help Me Out

Fri, 15 May 2015 08:59:43 GMT

ok i will try it now and let you know!!

Thanks

Re: Help Me Out

preminqlik — Fri, 15 May 2015 09:06:03 GMT

small correction in above gysberts exp ..(Closing bracket for num())

If( Num(Left(ItemCode,2),'00' ) >= 07 and Num(Left(ItemCode,2),'00') <= 99, Itemname) as STORES&Spares

Re: Help Me Out

Gysbert_Wassenaar — Fri, 15 May 2015 09:08:14 GMT

Fixed. Thanks!