Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

siva_boggarapu
Contributor II

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

Hello,

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

1 Solution

Accepted Solutions
MVP
MVP

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

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

3 Replies
MVP
MVP

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

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
Contributor II

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

Hello Miguel,

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

shubham_kumar
Contributor III

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

thanks for the information