topic Limit Selections in filter to one in Visualization and Usability

Limit Selections in filter to one

Mon, 09 Jan 2017 19:37:00 GMT

Hi,

I have a filter with merchant data. How can I limit an user to select only one value from filter drop down?

I do not want user to select multiple merchant names in the Filter List.

Please advise. Thanks.

Re: Limit Selections in filter to one

girirajsinh — Mon, 09 Jan 2017 20:34:29 GMT

Hi Chaitanya

You can do that by selecting "always one selected value" as follow.

Remember to select one value before you open the property of list box.

I hope this answer helps you

Re: Limit Selections in filter to one

Mon, 09 Jan 2017 21:08:22 GMT

Hi girirajsinh,

Thanks for reply but I am not using Qlik View. We are using Qlik Sense. Can you guide me for that? Thanks.

Re: Limit Selections in filter to one

girirajsinh — Mon, 09 Jan 2017 21:47:48 GMT

oh I missed that.

There is some info in following thread here , see if that helps

Qlik Sense Filter pane

Re: Limit Selections in filter to one

Anonymous — Mon, 09 Jan 2017 22:07:34 GMT

I don't think this option is available in Qlik Sense but as work around you can add a calculation condition to the chart that requires the user to make a selection before data is displayed.

Try adding this condition to your chart: GetSelectedCount(MerchantName)=1

Re: Limit Selections in filter to one

kangaroomac — Tue, 10 Jan 2017 03:01:17 GMT

I had a similar issue and solved it by using an extension (think it was called bi-era.com_listbox).

It allows you via a property setting to only accept one value selected at a time.

Re: Limit Selections in filter to one

andrespa — Tue, 10 Jan 2017 14:32:57 GMT

Currently that's not possible using native QS objects. As Ian said, there's an extension (GitHub - KumarNatarajan/qliksenselistbox: Qlik Sense Listbox Extension) but it seems to be out of date (probably it was built for QS 1.0) and is not even listed on the Qlik Branch. So I would not recommend it's use. There's another option (if suits you're project needs) through mashup integration+, of course the handicap is that you have to have some knowledge on web development. You can program the 'one selected value' functionality using JavaScript.

Hope it helps,

Andrés

Re: Limit Selections in filter to one

Anonymous — Tue, 13 Feb 2018 14:34:56 GMT

Hi Andres,

Could you give me a hint how to start with that custom javascript functionality to limit the selection only for 1 value?

Thanks,

Zoltan

Re: Limit Selections in filter to one

rittermd — Tue, 13 Feb 2018 19:39:28 GMT

There are some extensions that have this as an option.

Re: Limit Selections in filter to one

andrespa — Wed, 14 Feb 2018 08:15:10 GMT

Hi Zonltan when I reply to this post there wasn't any extension to do that, today I made a search on the Qlik Branch and I found this one:

http://branch.qlik.com/#!/project/598c6b041cfdc8bde4c49def

You can download or see the source code they have in Github to have a clue in how to do it yourself if you want.

Hope it helps,

Andrés

Re: Limit Selections in filter to one

DBIT — Fri, 02 Jun 2023 10:27:16 GMT

5 years later, is this still not a thing? I have a requirement to have the user make multiple selections before a table appears and displaying each selection option is dependant on the previous one being selected before it appears, but I do not want to force a selection to be already made the instant the user enters the app or that will enable the second selection to appear already.