Qlik Sense. Filter. How to select all previous value?

[brabbi1989]

Hi. I'm new in Qlik Sense. I'm working on the issue when user want select in filter one value and automatic select all previous values. For example, when user select 5, values 4,3,2,1 should be selected automatically.

How can I do it? 

Thank for help.

[teiswamsler · Accepted solution]

Hi Brabbi

A quick fix is to use following statement in the search field "<5>=1"

Otherwise a more complex solution is to build a dummy table contaning value to select and the related value. Then use masterfield in the dummy table as a filter.

Br.

Teis

[brabbi1989]

Hi Teis. Thanks for your reply. How can I automatically set value "<5>=1" in search field? 

[teiswamsler]

Hi @brabbi1989

It depend on the QS version you are on.

I Nov 2018 it can be done with "Qlik Sense Dynamic Default Bookmark Selection On Open"

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Bookmarks/set-defaul...

Br.

Teis

[brabbi1989]

I use September 2018. How do you think, in case when I want to use input field (I have added it use extension input Variable) and button for setting this value what solution I need?

Thank

[teiswamsler]

Hi @brabbi1989

Maybe this can work, and you will be able to selected in a native filter object with disired dimension

set analysis

{< Fieldselected, Fieldselection = {"<=$(=only(Fieldselected))"}  >}

Br.

Teis

[brabbi1989]

Hi @teiswamsler
I have tried. I wrote this in filter expresion. It didn't work. Maybe exists other idea?

Thanks

[teiswamsler]

Have you change "Fieldselected" to the field the user will make the selection in?

[brabbi1989]

Yes, sure

[teiswamsler]

can you provide a small sample app?