Help Me Out

[#1]

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.......!!!!!!!!!!!!!!

[qlikviewwizard]

Hi atulshishodia,

Try the below:

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

Hope this will helps.

[Gysbert_Wassenaar]

Perhaps like this:

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

[#4]

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

Thanks

[preminqlik · Accepted solution]

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

[Gysbert_Wassenaar]

Fixed. Thanks!