Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Anonymous
Not applicable
Author

Hi Benjamin,

Please check this thread:

Mandatory always one selected value in qliksense

It could help you.

Regards,

Sílvia

tomasz_tru
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

mato32188
Specialist
Specialist

Hi Benjamin,

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

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

BR

Martin

ECG line chart is the most important visualization in your life.
stantrolav
Partner - Creator II
Partner - Creator II

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.

beck_bakytbek
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

Anonymous
Not applicable
Author

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

marek7700
Contributor II
Contributor II

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

Dzieki, Marek

sonakshi10
Contributor
Contributor

Can this be done without using an extension?

Vegar
MVP
MVP

@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...