topic Logic Help in QlikView

Logic Help

abhaysingh — Sat, 25 Jul 2015 08:38:58 GMT

Hi,

I have few invoices start from DN like DN14/2014/123,, I don't want to include in my data.. how I can put where condition in that case

load invno,

field2,

field3

from table where invno<> '*DN*'

not working...

pls suggest

swuehl — Sat, 25 Jul 2015 08:41:01 GMT

from table

where not invno like '*DN*';

MK_QSL — Sat, 25 Jul 2015 08:50:14 GMT

load

invno,

field2,

field3

from table

where Not WildMatch(invno,'DN*');

Kushal_Chawda — Sat, 25 Jul 2015 09:15:12 GMT

Load *

From Table

where not wildmatch(invno,'DN*')