Solved: What is the alternate for 'Not in' in QlikView? - Qlik Community

siva_boggarapu · ‎2011-06-21

Hello,

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

Miguel_Angel_Baeyens · ‎2011-06-21

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.

BI Consultant

Miguel_Angel_Baeyens · ‎2011-06-21

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.

BI Consultant

siva_boggarapu · ‎2011-06-21

Hello Miguel,

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

Anonymous · ‎2011-06-21

thanks for the information