topic Re: Wildmatch function not executing!!! in QlikView

Wildmatch function not executing!!!

abhishek_bigdat — Thu, 11 Dec 2014 15:44:53 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!!

Re: Wildmatch function not executing!!!

arthur_dom — Thu, 11 Dec 2014 19:16:25 GMT

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

Re: Wildmatch function not executing!!!

abhishek_bigdat — Fri, 12 Dec 2014 04:31:13 GMT

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);

Re: Wildmatch function not executing!!!

abhishek_bigdat — Fri, 12 Dec 2014 04:32:05 GMT

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

Re: Wildmatch function not executing!!!

arthur_dom — Fri, 12 Dec 2014 12:31:03 GMT

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

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,