Wild match function not executing!!

abhishek_bigdat — Fri, 12 Dec 2014 04:34:27 GMT

Hey i am trying to create a pivot table as given in the excel being attached

And also i have create a data mapping for material description

if( Match([MM Material Grp Desc],'Condensing Units','Evaporating Units'),'REF UNITS',if([MM Material Grp Desc]='Mortury','Mortury','Insulation'))as Description,

if( [A/c assign.]=2,'MFG Products',if( [A/c assign.]=1,'Traded Product',if([Sales Order Type]='ZINS','Installation',if( WildMatch([WBS Element],'DEF*'),'Others'))))as TYPE,

So the wildmatch doesnt function in this case as i want to.

Like i will be able to Show Others under the Profit Center table if the Wildmatch function works.

Let me know.Thanks.Really Urgent!!

topic Wild match function not executing!! in QlikView

Wild match function not executing!!