Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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_...
{< 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
Hi,
Please advise and also if I have to use "%SEND" or "SEND%", the what should I have to use?
Thanks,
Sandip
"*SEND" or "SEND*", respectively
Hi,
Then when we should use? sign in set analysis? this answer will increase my knowledge.
Count({<DOCUMENT_LATEST_STATUS = {"UNDELIVERED"}>+
<DOCUMENT_ERROR_STEP={"*SEND","SEND*"}>}distinct FILE_ID)
this is how you write OR condition in Set analysis
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_...