To filter only exact match - FilterPane

[Bala_s]

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

[Bala_s]

Hi @marcus_sommer , @tresesco , @swuehl 

Any suggestion please 

Thanks in Advance...

Bala

[Chanty4u]

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

[PrashantSangle]

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

[tresesco]

For exact match, enclose your search string withing parenthesis, like:

(AA), for multiple values, separate values by pipe, like  (AA|BB|CCC)

[Bala_s]

@Chanty4u

Actually, the requirement is not to use any symbol in the search box. Users just copy and paste in the search box. 

Thanks,

[Bala_s]

Hi @PrashantSangle 

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

[Bala_s]

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

[tresesco]

@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.

[techguy100]

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