Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I eliminate data with a certain string of characters?

Hi,

I have a certain amount of information associated to OrderID's - which are all numeric. However, we have test orders in the system (a lot of them) that all start with 'F'.

I want to try and eliminate these dummy orders and their associated information - but I'm not sure how to write that into the script. in SQL, I use the like function with a wildcard - but it looks like the wildmatch function in Qlikview doesn't duplicate this exactly.

Any suggestions?

Example:

DUMMY DATA        REAL ORDERID

     F653519                    1089136

10 Replies
Not applicable
Author

I re-tried this after we fixed some seemingly unrelated issues and this did the trick, thank you!