Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
abhishek_bigdat
New Contributor II

Wildmatch function not executing!!!

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

Tags (2)
4 Replies
arthur_dom
Contributor III

Re: Wildmatch function not executing!!!

  Deepak the excel only didn't help... could you paste the scrip of loading the data?

abhishek_bigdat
New Contributor II

Re: Wildmatch function not executing!!!

Booking:

LOAD [Sales Office]as [Booking_Sales Office],

     [Sales Order Type],

     [Sales Order],

     [SO Item Date],

     [Sold to Party Code],

     [Sold to Party Name],

     [Material NO],

     [Order Quantity],

     [Total Sales Value],

     VAT as Booking_VAT,

     CST as Booking_CST,

     [Total Inv. Value],

     Plant,

     [Distr Channel],

     UOM,

     Currency,

     [Sales Amount],

     [Material Cost],

     [Purchase Cost],

     [Gross Margin %],

     [Total Cost],

     [Net GM %],

     [Net GM],

     [Gross Margin],

     [Sales Employee Code],

     [Sales Employee Name],

     [Foreign Currency],

     [Original Material Gr],

     [Original Material Gr1],

     [A/c assign.],

     [Add Vat],

     [Additional Discount],

     [Addl Sales Commssion],

     [Cash Discount],

     [Customer Group],

     [Delivery Charges],

     [Divi Desc],

     [Education Tax],

     [Extended Warranty Ex],

     [Freight Charges],

     [Handling Charge],

     [Higher Education Tax],

     INDUSTRY,

     [Installation Charges],

     Insurance,

     [Insurance Charges],

     [Material Group 1],

     [Material Group 2],

     [Material Group 3],

     [Material NO Desc],

     [MG 1 Desc.],

     [MG 2 Desc.],

     [MG 3 Desc.],

     [MM Material Grp Desc],

     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,

     [MM Matrial Grp],

     Octroi,

     [Octroi Charges],

     [Other Expenses],

     [Packing Charges],

     [Plant Desc],

     [Pos No],

     [Primary Freight],

     [Qty/Tonnage Disc],

     [Reason for Rejection],

     Region,

     Retailer,

     [Retailer desc],

     [Sales Commssion],

     [Sales Dealer],

     [Sales Dealer Name],

     [Sales District],

     [Sales Office Desc],

     [Sales Order Desc],

     [Secondary Freight],

     Segment,

     [Service Dealer],

     [Service Dealer Name],

     [Service Tax] as [Booking_Service Tax],

     [Ship to Party],

     [Ship to Party Name],

     [Social Security Cess],

     [Sold to Party PO Date],

     [Sold to Party PO Number],

     Tonnage,

     TOP,

     Usage,

     [User ID],

     [User name],

     [Valuation Field],

     [WBS Element],

     [Work Order Date],

     [Work Order No],

     [Value in Foreign Cur],

     Division as Booking_Division

FROM

(ooxml, embedded labels, table is Sheet1);

abhishek_bigdat
New Contributor II

Re: Wildmatch function not executing!!!

This is the script used for loading the data.Would require a quick turnaround.

arthur_dom
Contributor III

Re: Wildmatch function not executing!!!

So i think you attached a wrong excel.... 

Screen Shot 2014-12-12 at 10.22.41.png

Bu looking for your Nest if, it could be something misplaced. the wildmatch is in a else of sales = ZINS, that is in a else of A/c assing = 1 , that is on a else of A/C Assign = 2 ... And the wildmatch if false will bring null... it is that order ?

    

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',

                     null()

               )    

          )

       )

)

               as TYPE,

Community Browser