topic Re: How to filter rows Where not start with in QlikView

How to filter rows Where not start with

Anonymous — Thu, 16 Nov 2017 12:56:31 GMT

Hi All ,

I need to filter where Assignment group not start with ML- And UK-ML- then Company= A .

Input:

Out put:

Thanks,

Krishna.

shraddha_g — Thu, 16 Nov 2017 12:59:34 GMT

If(wildmatch([Assignment group],'UK-ML*','ML*'),[Assignment group],'A')

Chanty4u — Thu, 16 Nov 2017 13:00:47 GMT

try

load *,

..... from

where not like '*ML*';

=aggr(if(NOT WildMatch(Assignmentgroup,'*ML*'),Assignmentgroup), Assignmentgroup)

if it is in script remove aggr

if(NOT WildMatch(Assignmentgroup,'*ML*'),Assignmentgroup)

Chanty4u — Thu, 16 Nov 2017 13:03:33 GMT

i thinks it should not widlmatch