topic Re: Qlik Sense. Filter. How to select all previous value? in App Development

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

brabbi1989 — Tue, 27 Nov 2018 11:42:54 GMT

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.

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

teiswamsler — Tue, 27 Nov 2018 12:42:36 GMT

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

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

brabbi1989 — Tue, 27 Nov 2018 13:05:07 GMT

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

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

teiswamsler — Tue, 27 Nov 2018 13:11:10 GMT

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-default-bookmark.htm

Br.

Teis

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

brabbi1989 — Tue, 27 Nov 2018 13:18:22 GMT

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

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

teiswamsler — Tue, 27 Nov 2018 13:26:59 GMT

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

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

brabbi1989 — Tue, 27 Nov 2018 13:43:46 GMT

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

Thanks

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

teiswamsler — Tue, 27 Nov 2018 13:47:07 GMT

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

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

brabbi1989 — Tue, 27 Nov 2018 13:48:15 GMT

Yes, sure

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

teiswamsler — Tue, 27 Nov 2018 14:01:27 GMT

can you provide a small sample app?

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

brabbi1989 — Tue, 27 Nov 2018 14:22:49 GMT

@teiswamsler

It looks a strange, but I can't publish my app cause I have error:The contents of the attachment doesn't match its file type.

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

brabbi1989 — Tue, 27 Nov 2018 14:54:20 GMT

@teiswamsler maybe you can provide some example or screen?