We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
Currently I'm looking for an exact match in a datasource field which works well.
Checking if field 'PSPHierarchie.Ebene1' is "ABC"
The condition statement:
[Datasource].[Plankonsolidierung].[Field].[PSPHierarchie.Ebene1].Contains("ABC")
Now I like to check if the string in the field does NOT begin/contain one of these two strings:
"GR_" or "AP_"
The values in the field should contain strings like "GR_xxxx" or "AP_xxxx". In error the field may contain "GF_abcdef" or "AC_12345" or anything else.
The check is used to identify it there are strings which do not begin with "GR_" or "AP_" and send a mail if occured.
Any idea?
Regards Michael
0 Votes
2 Comments
Michael Gemmer posted almost 2 years ago
I don't have this dialog in 2.1.1
It looks like this and I don't find an option to "filter" the search values and select "Perform Match Filter". I need to enter the expression.
But on the bottom of your screenshot I see parts of an expression string. Is this the corresponding string of your filter statment with the "perform match filter" option? Could you provide it.
PS: 3.x looks nice. Hope to receive it soon.
Regards Michael
0 Votes
Emma Camacho posted almost 2 years ago Admin
Hallo Michael,
I would solve it somehow like this:
In order to use wildcard in Qlik, please check the Perform Match Filter checkbox.
Kind regards, Emma
0 Votes
Login or Sign up to post a comment