Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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

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.

1 Solution

Accepted Solutions
Partner
Partner

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

View solution in original post

11 Replies
Partner
Partner

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

View solution in original post

Contributor
Contributor

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

Partner
Partner

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

Contributor
Contributor

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

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

Contributor
Contributor

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

Thanks
Partner
Partner

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

Contributor
Contributor

Yes, sure
Partner
Partner

can you provide a small sample app?