Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

There are freeware available for similar functionality.

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

2. Qlik Branch

Highlighted
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

Highlighted
Partner
Partner

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

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

Highlighted
Contributor III
Contributor III

Unfortunately not accessible anymore...

Highlighted
Contributor III
Contributor III

As well not accessible anymore.

Highlighted
Contributor III
Contributor III

BI-Era is link is dead:(

Highlighted
Partner
Partner

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.

 

Highlighted
Contributor II
Contributor II

Perfect Solution!! Thanks

Highlighted
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!