Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

Filter only one data

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.

8 Replies
jmartineze
Partner - Creator
Partner - Creator

hi,

maybe you can use a calculated condition in chart

aveeeeeee7en
Specialist III
Specialist III

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
Creator II
Creator II

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.

sandeepsingh_0-1680264666603.png

 

louise119
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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
Creator II
Creator II

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
Creator III
Creator III
Author

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

sandeep-singh
Creator II
Creator II

Please follow the snapshot. You need to add the action

sandeepsingh_0-1680494047828.png