Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restricting a filter to only one possible value

Hi,

I just started using Qlike Sense Desktop - so hopefully you can help me a bit.

I am using a filter pane, where I can select different years (2010, 2011, ...)

One of my visualisations should show sales for different companies on a map.


My problem is that one can select more than just one year (e.g. 2016) which would lead to false values.

Is it possible to program the filter pane such that only one year can be selected and multiple selection is disabled?

Or is there a way to work around?


Hopefully somebody can help me 🙂


Thanks

Benjamin

9 Replies
Creator II
Creator II

Hi Benjamin,

Please check this thread:

Mandatory always one selected value in qliksense

It could help you.

Regards,

Sílvia

Specialist
Specialist

If you don't want to use extensions (or create mashup) you can prevent visualisation from rendering in Data handling/Calculation condition:

if(getselectedcount([YEAR FIELD])=1, 1,0)

Tomasz

Creator III
Creator III

Hi Benjamin,

there is quite good extension to have pre-selected one value.

https://github.com/balexbyrd/sense-FieldUI

BR

Martin

Partner
Partner

Try using this extension: http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

I used Variable Select option with predefined values. This variable can be used in Set Analysis of your expression.

It helped me for such problem. This is stable extension.

Master
Master

Hi Benjamin,

i understand your business situation and therefore i have a suggestion:

look at this: http://branch.qlik.com/?&_ga=2.200489002.547389710.1494418632-663743194.1483354205#!/project/58e20b0...

you can download this extension (i impelemented it in my desktop and server and it does work great).

necessary steps if you downloaded this extension:

1. in tab Actions (within Extension): in Field: First Action select : Apply Bookmark

2. before you should create a Bookmark according your parameters

3. and if you Select: Apply Boomark (with in Extension: tab First Action), this will work like a filter (see attached)

i hope that helps

Beck

Creator II
Creator II

Download below extension and copy in the extension folder and refresh your sense app

then drag the list box and go to list box settings and enable "Always one selected value" , set default value to be selected

Regards,

Devendar

Contributor II
Contributor II

Thanks! I can't use extensions in the cloud so this was perfect!

Dzieki, Marek

Contributor
Contributor

Can this be done without using an extension?

Partner
Partner

@sonakshi10 this is supported by Qlik Sense without extension now. Take a look at this page: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/DataSource/select-single...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes