topic Re: Where not match in QlikView

Where not match

penpayom — Wed, 01 Aug 2018 02:15:00 GMT

I want to use Where not match function ,but it error ,Where I wrong?

Please help me.

Thank you.

vishsaggi — Wed, 01 Aug 2018 02:49:08 GMT

‌yyou cannot use like that in the field list try like

LOad field1,

field2

from tablename

where not match(Knot_mc_kat, ‘GF-Stock’,’NON-Fab’);

BalaBhaskar_Qlik — Wed, 01 Aug 2018 07:34:32 GMT

Try this:

DFIT_KNIT_YEAR:

LOAD

KNIT_MC_YEAR,

IF(NOT MATCH(KNIT_MC_CAT,'GF-STCOK','NON-FAB'),KNIT_MC_CAT) AS KNIT_MC_CAT,

KNIT_MC_GROUP,

.....

From abc;

Chanty4u — Wed, 01 Aug 2018 07:37:56 GMT

try this

write below code as last line

where field not in('Value1','Value2');