New to Qlik Sense

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