Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

On Filter allow only one selection

Hi All,

I have a filter with Emplyee_Code. How can I limit an user to select only one value from filter drop down in Qlik Sense ?

I do not want user to select multiple Emplyee_Codes in the Filter List.



Here i can select multiple selections but i do not want to select multiple selections only one selection should allow.
















Please provide the solution.

1 Solution
7 Replies
Contributor III
Contributor III


is there any other way to display the data.

Partner - Master III
Partner - Master III

What @sunsun566  has wrote to you is the only option you have but the limitation is that it's applied to the whole app.
Another option could be using Vizlib filter object, take a look at ( which you can set with the option "only one value selected".
Vizlib extensions are free up to 5 users.

I hope it can helps.

Contributor III
Contributor III

If you don’t want to affect the report.
You can add a new dimension, such as EMPCODE_NAME as EMPCODE_NAME_Filter.
Then the user can only select a value through EMPCODE_NAME_Filter.

Partner - Specialist III
Partner - Specialist III


steps are:

1- Make single selection from Emplyee_Codes

2- Click Edit sheet button on the sheet

3- Click on fields (on left side of the page)

4- Click Emplyee_Codes field, then a dialog box opens 

5- Click on fields setting icon and select Always one value selected checkbox.

Creator III
Creator III


For future reference sake I thought I'd offer this option as well. Since the "Always one value selected checkbox" affects the whole app which includes all states I wanted to find a way that was more dynamic. While not perfect, using the only() function will force the user to turn the filter off before selecting the next value. This can be placed in an aggr() function aggregated by itself to force it back to a dimension.

=aggr(only(Emplyee_Codes), Emplyee_Codes)


Partner - Contributor II
Partner - Contributor II

Hi @anthonyj, thanks a bunch for the detailed explanation of aggr(only()), worked like a charm! I had the same motto to make it dynamic affecting the filters only instead of affecting the whole sheet.