Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

10 Replies
girirajsinh
Creator III
Creator III

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
Author

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

oh I missed that.

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

Qlik Sense Filter pane

Anonymous
Not applicable
Author

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

kangaroomac
Partner - Creator II
Partner - Creator II

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

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

Anonymous
Not applicable
Author

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

There are some extensions that have this as an option.

andrespa
Specialist
Specialist

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