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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to exclude a value from a field

Hi,

How to exclude the values starting with '++' from below dimension field?

Capture.PNG

 

Thanks

1 Solution

Accepted Solutions
tresB
Champion III
Champion III

My be using wildmatch(), like:

Load
Field
From <> where not wildmatch(Field, '++*');

View solution in original post

2 Replies
tresB
Champion III
Champion III

My be using wildmatch(), like:

Load
Field
From <> where not wildmatch(Field, '++*');
abc_18
Creator II
Creator II
Author

Hi Tresesco,

 

Thank you very much, it works as expected.

Regards