Filter only one data

[louise119]

Is there a function to allow only one item to be selected in the filter?

With the current filter, multiple items can be selected, and the search results of multiple items are displayed. However, when all items are selected, a memory error occurs. To prevent this, I would like to prepare a filter that allows only one item to be selected. is.

I tried filter "always one selected value", but it affects other sheets . so it is not good for my situation.
I want to affect only one sheet.

[jmartineze]

hi,

maybe you can use a calculated condition in chart

[aveeeeeee7en]

Hi @louise119 

You can use GetSelectedCount(FieldName)=1 condition in your chart.

Using this will generate & display chart only when Filter has one selected value else it will grayed out.

If there are more than 1 selection then in that case it will pop-up custom message "The chart will generate results only when there is one value is selected"

Regards,

Av7eN

[sandeep-singh]

Search the required field in assets panel. Right click on that field -> Fields settings. Check the box "Always one selected value". Attached snapshot for your reference.

[louise119]

Thank you. 
I tried the solution you told, but can it use on filter ?

I want to control that only one value can be selected in the filter.

[louise119]

Thank you.
I tried the solution you told, but it affects other sheets, right?

I want to control so that only one value can be selected in the filter for one sheet.

[sandeep-singh]

For the rest of the sheets you can add a page level action -> Clear Selections in field -> Field name. it will remove this selection from other sheets.

[louise119]

Thank you so much.
But. I couldn't find " Clear Selections in field" in page action...
Where can you find ?

[sandeep-singh]

Please follow the snapshot. You need to add the action