Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Limit Selections in filter to one

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.

9 Replies
girirajsinh
Contributor III

Re: Limit Selections in filter to one

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

Not applicable

Re: Limit Selections in filter to one

Hi girirajsinh,

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

girirajsinh
Contributor III

Re: Limit Selections in filter to one

oh I missed that.

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

Qlik Sense Filter pane

Highlighted
okolyug16
Contributor II

Re: Limit Selections in filter to one

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

Capture.PNG

Partner
Partner

Re: Limit Selections in filter to one

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.

andrespa
Valued Contributor

Re: Limit Selections in filter to one

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

zoltan_farkas
New Contributor III

Re: Limit Selections in filter to one

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

rittermd
Honored Contributor

Re: Limit Selections in filter to one

There are some extensions that have this as an option.

andrespa
Valued Contributor

Re: Limit Selections in filter to one

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