not match, Not LIKE problem

Tue, 02 Aug 2011 22:18:07 GMT

Hi All,

This is a really small problem. I am trying to filter out these below names and get all other names, hence i have put a <> (not) sign. But still i get all these names. What is the mistake here?

=if( SUBJECT_AREA <> 'Bop_Settlement'

or SUBJECT_AREA <> 'Conf_Dim'

or SUBJECT_AREA <> 'HODS_CTIX_DD'

or SUBJECT_AREA <> 'Reporting'

or SUBJECT_AREA <> 'WAR'

or SUBJECT_AREA <> 'WebTrends' or wildmatch(SUBJECT_AREA,'CODS*')=0,SUBJECT_AREA)

Thanks in advance!

not match, Not LIKE problem

johnw — Tue, 02 Aug 2011 22:19:30 GMT

Use "and" instead of "or".

not match, Not LIKE problem

Wed, 03 Aug 2011 18:20:31 GMT

Thanks so much!

topic not match, Not LIKE problem in QlikView

not match, Not LIKE problem

not match, Not LIKE problem

not match, Not LIKE problem