Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Need your input for the exact match issue in Filter Pane.
Without using any extra symbols or functions in the search box (ex: parenthesis etc..), the filter pane should filter only if we have an exact match value.
My attached screenshot shows matching values when I key in the values in the search box.
The result I'm looking for is, no matching values should pop up unless the user enters an exact match value.
Thanks in Advance...
Bala
Hi you can try this
To achieve an exact match search without using any extra symbols or functions, you can modify the search string by using the "=" symbol. This symbol specifies an exact match search. For example, if you want to search for a value "apple", you can enter "=apple" in the search box instead of just "apple".
For multiple values
=value1|=value2|=value3
can you reshare your attachment??
In which product you are trying this?
In qlik saas you will find below option for it
check that.
If you need alternate solution in qlik then in
filter pane > Add Field > click fx > aggr(fieldName,fieldName)
Regards,
Prashant Sangle
For exact match, enclose your search string withing parenthesis, like:
(AA), for multiple values, separate values by pipe, like (AA|BB|CCC)
Actually, the requirement is not to use any symbol in the search box. Users just copy and paste in the search box.
Thanks,
I'm working Qlik Sense Enterprise May 2022 version.
Have tried aggr(fieldName,fieldName) still, it shows the matching values in the fiter pane.
Thanks
Hi @tresesco,
Thanks for the reply.
Actually, users don't want to use any symbols in the search box. They just copy and paste the list of Id's in filter pane.
Thanks
@Bala_s , it would not be working that way in search box that comes in qlik. Alternatively, you can create a custom solution for similar experience. You can get the input from users (copy-pasted) and then create a search string (by adding additional characters, like '|' and removing few undesirable) to replicate one that is expected by qlik, and perhaps use a button 'clik to search' to trigger the selection based on the generated string.
To achieve an exact match in the filter pane without using any extra symbols or functions, you can try the following steps:
Click on the filter pane dropdown and select "Custom..."
In the "Custom Panel" window that appears, select "Search Fields" from the "Search" dropdown.
Click on the "Add" button to add a new search field.
In the "Field Name" dropdown, select the field that you want to filter on.
In the "Search String" field, enter the exact value that you want to match.
Select the "Exact Match" checkbox.
Click on the "Apply" button to apply the filter.
This should filter the data based on the exact match value entered by the user in the filter pane search box. The filter will only show the exact match value and not any other similar values.
Note: This approach will only work if the field being filtered is a dimension field. If it is a measure field, you may need to consider using other methods to achieve an exact match.
Regards,
Rachel Gomez