Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bsbernabe
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
StarinieriG
Partner - Specialist
Partner - Specialist

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
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

you could use where and match like this

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

Anil_Babu_Samineni

Perhaps this in the end of load script?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)