Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how to use except/ not exist in qlikview

Hello There,

How to make script loading data to remove value not need sample I want to remove 300, 285 in a list. how can I do that?

Sample Data:

Code
300
285
299
56
216

The result should be:

Code
299
56
216

 

Best Regards,

Bing

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

you could use where and match like this

LOAD
Code
From File
Where Match(Code, '300','285')=0;

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi,

you could use where and match like this

LOAD
Code
From File
Where Match(Code, '300','285')=0;

View solution in original post

Highlighted

Perhaps this in the end of load script?

Where Not Match(Code, '300', '285')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)