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.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kpradeep5610
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.

 

 

filter.JPG

 

 

 

 

 

 

 

 

 

 

 

 

Please provide the solution.

1 Solution
7 Replies
kpradeep5610
Contributor III
Contributor III
Author

Hi 

is there any other way to display the data.

agigliotti
Partner - Master III
Partner - Master III

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

Gabriel
Partner - Specialist III
Partner - Specialist III

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

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)

 

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