topic Expression Error in QlikView

Expression Error

Anonymous — Wed, 02 Dec 2015 09:27:26 GMT

I want to delete any thing start with 'DUM'

I try this expression but it doesn't work !

=if(left ([P_PO Number]) = 'DUM', PurgeChar([P_PO Number],''))

tamilarasu — Wed, 02 Dec 2015 09:30:34 GMT

Hi Mohammed,

Try,

=if(Left ([P_PO Number],3) <> 'DUM', [P_PO Number])

marcus_sommer — Wed, 02 Dec 2015 09:31:57 GMT

Try: if(left([P_PO Number], 3) <> 'DUM', [P_PO Number])

- Marcus

Kushal_Chawda — Wed, 02 Dec 2015 09:33:53 GMT

try this

=if(not wildmatch(lower(trim([P_PO Number])),'dum*'),[P_PO Number]) as [P_PO Number]

PrashantSangle — Wed, 02 Dec 2015 09:35:25 GMT

Hi,

One more solution

try with match() or wildmatch()

if(not wildmatch([P_PO Number],'DUM*'),[P_PO Number])

if(not match([P_PO Number],'DUM*'),[P_PO Number])

Regards