Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Not applicable

Re: Exclution of few values from a field

You can use exist function..

attached example from cook book.

Karthik

View solution in original post

2 Replies
Highlighted
Not applicable

Re: Exclution of few values from a field

You can use exist function..

attached example from cook book.

Karthik

View solution in original post

Highlighted
Partner
Partner

Re: Exclution of few values from a field

Hey Karthik.. Thanks.. it's working fine!! Thanks thanks!!! 🙂