topic Re: Wildcard in QlikView

Wildcard

kevbrown — Thu, 19 May 2016 13:38:59 GMT

I need to pull out certain data from a field where the code in that field begins RM, so have the expression, if(UPC='Rm*', 1) but it's not pulling anything out. How do i do a wildcard search for a chart?

Kev

Re: Wildcard

Kushal_Chawda — Thu, 19 May 2016 13:40:04 GMT

if(wildmatch(UPC,'Rm*'),1) as Flag

if( UPC like 'Rm*',1) as Flag

Re: Wildcard

tamilarasu — Thu, 19 May 2016 13:41:16 GMT

Try this,

If(Wildmatch(UPC,'Rm*'),1)

If(Left(UPC,2)='Rm',1)

Re: Wildcard

sunny_talwar — Thu, 19 May 2016 13:45:51 GMT

Try this:

If(WildMatch(Upper(UPC), 'RM*'), 1)

If(Index(Upper(UPC), 'RM'), 1)

Thanks tamilarasu

Re: Wildcard

trdandamudi — Thu, 19 May 2016 13:53:25 GMT

May be this:

= if(UPC like 'Rm*', 1)

=if(upper(UPC) like 'RM*', 1)