On Filter allow only one selection

[kpradeep5610]

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.

[sunsun566 · Accepted solution]

Hi 

refer to https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/DataSource/select-si...

[kpradeep5610]

Hi 

is there any other way to display the data.

[agigliotti]

Hi,
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 (https://community.vizlib.com/support/solutions/folders/35000206472%3E) which you can set with the option "only one value selected".
Vizlib extensions are free up to 5 users.

I hope it can helps.

[sunsun566]

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.

[Gabriel]

@kpradeep5610 

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.

[anthonyj]

Hi,

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)

[ar5]

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.