Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select only one value in filter pane

Hello everyone,

I have a problem with Qlik Sense. Indeed, I want to limit the selection to one value in a filter pane.

Is it possible ? If I can do that, do you have any idea to suggest me ?

Thank in advance to your answer !

Best regards,

SD

18 Replies
shraddha_g
Partner - Master III
Partner - Master III

There are freeware available for similar functionality.

1.https://github.com/KumarNatarajan/qliksenselistbox/tree/master/bi-era.com_listbox

2. Qlik Branch

berndjaegle
Creator II
Creator II

Thanks Shraddha.

Installed the BI-Era one and works... but now my slider buttons look strange. Size doesn't fit and the radio buttons have an additional grey box next to the check box. And this in the whole application... Not so nice.

Any ideas how to fix this?

Only OneSelected_ Qlik Sense2.jpg

Only OneSelected_ Qlik Sense.jpg

shraddha_g
Partner - Master III
Partner - Master III

I have used it as horizontal listbox.it looks better dat way..

2nd extension i.e Climber one is also good with similar functionality

johannesholzer
Contributor III
Contributor III

Unfortunately not accessible anymore...

johannesholzer
Contributor III
Contributor III

As well not accessible anymore.

johannesholzer
Contributor III
Contributor III

BI-Era is link is dead:(

NicolaiF
Partner - Contributor II
Partner - Contributor II

For everyone who is not able to use extensions there is a work-around.

If you put this:

=AGGR(ONLY(my_filter),my_filter)

(Where my_filter is the dimension that you want to filter on)

in "Field" in one of your dimensions, in the filter pane.

This will make it so that:

  • When nothing is selected all filter options will be displayed. 
  • If the user tries to select multiple filter options in the filter Qlik will prompt "invalid parameters" and only select the first selection.
  • When a filter option is selected all other options are hidden and only the current selection is shown in the filter.
  • To make a new selection in the filter the current selection must be deselected.

 

resajdak
Contributor II
Contributor II

Perfect Solution!! Thanks

JMoreno
Contributor III
Contributor III

PERFECT SOLUTION!!

There should be an option by default in Qlik to allow users to select only 1 value in a specific filter pane. The latest version have that "Always one selected value"  for fields, but this doesn't allow for having NO selections in the filter if the user wants. 

 

Thank you!