Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

brijesh1991
Contributor III

Exclution of few values from a field

Hi guys, I had 100000 ApplicationNo in a SQL table. I am loading them like this: Load ApplicationNo from TableName; which will load all the ApplicationNos. Now I wanted to remove 5000 ApplicationNo(which are in  a Excel file) from whole list. Your suggestions and ideas are too importart. . . {I can't change anything in SQL table like adding a flag or something else since many other users are using the same table. All we have to do is in QVW file at loading time.} Best Regards, Brijesh

1 Solution

Accepted Solutions
Not applicable

Re: Exclution of few values from a field

You can use exist function..

attached example from cook book.

Karthik

2 Replies
Not applicable

Re: Exclution of few values from a field

You can use exist function..

attached example from cook book.

Karthik

brijesh1991
Contributor III

Re: Exclution of few values from a field

Hey Karthik.. Thanks.. it's working fine!! Thanks thanks!!! Smiley Happy

Community Browser