topic How to use WildMatch function here? in QlikView

How to use WildMatch function here?

Thu, 26 Mar 2015 06:58:39 GMT

Hi,

Here is the attached example Spreadsheet I need to get only from the field Channel = 40 and Division =AC and Partner =50.

Can anyone help me on this?

I tried the following in scrip but it is not working 😞

where wildmatch([Channel],[Division ],[Partner ], '*40*','*AC*','*50*');

maxgro — Thu, 26 Mar 2015 07:05:23 GMT

why wildmatch?

you can use a simple where Channel='40' and Division......

but if you want wildmatch, try

LOAD Component,

Channel,

Division,

Partner

FROM

amouunt.xlsx

(ooxml, embedded labels, table is Sheet1)

Where WildMatch(Channel&'-'&Division&'-'&Partner, '40-AC-50')

Ralf-Narfeldt — Thu, 26 Mar 2015 07:07:01 GMT

The load condition would be where Channel = 40 and Division = 'AC' and Partner = '50'

Thu, 26 Mar 2015 07:16:42 GMT

Thanks a ton Ralf 🙂