topic To filter only exact match - FilterPane in App Development

To filter only exact match - FilterPane

Bala_s — Fri, 05 May 2023 04:42:21 GMT

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

Re: To filter only exact match - FilterPane

Bala_s — Fri, 05 May 2023 04:52:09 GMT

Hi @marcus_sommer , @tresB , @swuehl

Any suggestion please

Thanks in Advance...

Bala

Re: To filter only exact match - FilterPane

Chanty4u — Fri, 05 May 2023 05:28:05 GMT

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

Re: To filter only exact match - FilterPane

PrashantSangle — Fri, 05 May 2023 06:04:25 GMT

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

Re: To filter only exact match - FilterPane

tresB — Fri, 05 May 2023 06:23:36 GMT

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

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

Re: To filter only exact match - FilterPane

Bala_s — Fri, 05 May 2023 06:41:53 GMT

@Chanty4u

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

Thanks,

Re: To filter only exact match - FilterPane

Bala_s — Fri, 05 May 2023 06:45:10 GMT

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

Re: To filter only exact match - FilterPane

Bala_s — Fri, 05 May 2023 06:47:06 GMT

Hi @tresB,

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

Re: To filter only exact match - FilterPane

tresB — Fri, 05 May 2023 07:33:55 GMT

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

Re: To filter only exact match - FilterPane

techguy100 — Wed, 10 May 2023 05:28:47 GMT

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

Re: To filter only exact match - FilterPane

Bala_s — Wed, 10 May 2023 06:53:50 GMT

Hi @techguy100

Are you referring to the Filter pane extension? Because we don't have a "Custom Panel" in the native Qliksense app.

Thanks,

Bala