
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
wild card characters * and ? in qlik sense
Hi ,
I need to implement the below logic:
Count of distinct FILE_ID where
DOCUMENT_LATEST_STATUS = UNDELIVERED or DOCUMENT_ERROR_STEP Like "%SEND%") and DOCUMENT_LATEST_STATUS = ERROR
So how can I use * and ? here in set analysis? Please advise and also if I have to use "%SEND" or "SEND%", the what should I have to use?
Accepted Solutions
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You use wildcards when part of the information is given as a string, but that value can have preceding or subsequent characters, respectively.
You can use it in set analysis to make sure that within the chart, not all values available in your model are selected, but only those for which exist associated value containing SEND either at the beginning or at the end of the string.
To be able to search in set analysis, the syntax is always
{< Field = {"*string_to_search*"} >}
Wildcards accepted are "*" or "?" along with "^" to search at the beginning of the field value.
More details: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Text_search_and_numeric_...
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
{< DOCUMENT_ERROR_STEP = {"*SEND*"} >}
Double quotes and star to search for the string SEND (case sensitive) within the values of the field DOCUMENT_ERROR_STEP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please advise and also if I have to use "%SEND" or "SEND%", the what should I have to use?
Thanks,
Sandip
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"*SEND" or "SEND*", respectively

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Then when we should use? sign in set analysis? this answer will increase my knowledge.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count({<DOCUMENT_LATEST_STATUS = {"UNDELIVERED"}>+
<DOCUMENT_ERROR_STEP={"*SEND","SEND*"}>}distinct FILE_ID)
this is how you write OR condition in Set analysis
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You use wildcards when part of the information is given as a string, but that value can have preceding or subsequent characters, respectively.
You can use it in set analysis to make sure that within the chart, not all values available in your model are selected, but only those for which exist associated value containing SEND either at the beginning or at the end of the string.
To be able to search in set analysis, the syntax is always
{< Field = {"*string_to_search*"} >}
Wildcards accepted are "*" or "?" along with "^" to search at the beginning of the field value.
More details: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Text_search_and_numeric_...
