What is the alternate for 'Not in' in QlikView?

[siva_boggarapu]

Hello,

Can any body tell me What is the alternate for 'Not in' in QlikView?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

I'd use

Table:
LOAD *
FROM File.qvd (qvd)
WHERE Match(ID, 'A', 'B', 'C') = 0; // load records where ID is not A, B nor C

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[siva_boggarapu]

Hello Miguel,

Thanks for giving right answer. Its really working for me.

[Anonymous]

thanks for the information