topic Re: LIST BOX - If none selected, select all in QlikView

LIST BOX - If none selected, select all

avantime — Wed, 25 Nov 2020 16:16:04 GMT

In the attached app I am loading 5 items, A, B, C, D, E.

In a listbox I am showing only A B C D, without E. I am also preselecting these 4 values.

The problem is that after I select one or more items in the listbox, once I clear the selection E is also selected by default.

How can I force the listbox to select ABCD by default?

Hope I made myself understood .

Re: LIST BOX - If none selected, select all

sunny_talwar — Thu, 09 Feb 2017 11:22:14 GMT

When you clear E is also selected? How can you select when you press clear? I am not sure how you are clearing? Can you explain?

Re: LIST BOX - If none selected, select all

surendraj — Thu, 09 Feb 2017 11:23:29 GMT

Select 4 at a time...(A,B,C,D)

enable-->set clear state--->save-->colse the app.

By your on open trigger it will defaultly show 4 selected values.

now even you clear selections, that are not cleared till you press reset clear state.

Re: LIST BOX - If none selected, select all

avantime — Thu, 09 Feb 2017 11:31:04 GMT

Check attached,

When I click "Clear selections" I want need the total value to be 10 (Select only ABCD).

Re: LIST BOX - If none selected, select all

sunny_talwar — Thu, 09 Feb 2017 11:32:47 GMT

Then use set analysis to exclude it?

Sum({<ITEM -= {'E'}>}VALUE)

Sum({<ITEM = -{'E'}>}VALUE)

Re: LIST BOX - If none selected, select all

tresB — Thu, 09 Feb 2017 11:39:22 GMT

May be like attached sample.

Re: LIST BOX - If none selected, select all

avantime — Thu, 09 Feb 2017 11:45:25 GMT

Yes, exactly like that

Can you please explain what you did?

Re: LIST BOX - If none selected, select all

avantime — Thu, 09 Feb 2017 11:48:35 GMT

I know how to exclude E from Sum, this is not what I need. I need to apply this selection over tens of formulas.

Re: LIST BOX - If none selected, select all

sunny_talwar — Thu, 09 Feb 2017 11:52:07 GMT

Very smart tresesco

He added a trigger to OnAnySelect

Re: LIST BOX - If none selected, select all

avantime — Thu, 09 Feb 2017 12:00:36 GMT

Works like a charm. Thank you!

Re: LIST BOX - If none selected, select all

avantime — Wed, 15 Feb 2017 15:09:14 GMT

Is it possible to tie this function to just a specific sheet? I tried adding "AND GetActiveSheetId()='SH01'" in the if condition, but it doesn`t work.

Thanks!

Re: LIST BOX - If none selected, select all

surendraj — Wed, 15 Feb 2017 15:18:39 GMT

Yes..You can apply the same trigger on

Right click-->Properties-->Triggers-->OnActivateSheet-->Select in field-->

Item==If(GetSelectedCount(ITEM)=0, '(A|B|C|D)', '('&Concat(DISTINCT ITEM, '|')&')' ).

This means when ever you select perticular sheet(SH01),this action will activated.

Re: LIST BOX - If none selected, select all

avantime — Wed, 15 Feb 2017 15:21:45 GMT

Thanks but this works until I select an ITEM, then it doesn`t work anymore. It needs to be tied to OnAnySelect..

Re: LIST BOX - If none selected, select all

surendraj — Wed, 15 Feb 2017 16:01:15 GMT

In your application you need to apply 2 triggers

1.select in field-->ITEM=(A|B|C|D)

2.select in field-->ITEM==If(GetSelectedCount(ITEM)=0, '(A|B|C|D)', '('&Concat(DISTINCT ITEM, '|')&')' ).

By this you no need to select ITEM.when ever you activates SH01.it will apply,Means it will be applicable to specific sheet only.

Re: LIST BOX - If none selected, select all

sunny_talwar — Wed, 15 Feb 2017 16:24:00 GMT

May be this?

=If(GetActiveSheetId() = 'Document\SH01',

If(GetSelectedCount(ITEM)=0, '(A|B|C|D)', '('&Concat(DISTINCT ITEM, '|')&')' ))

Re: LIST BOX - If none selected, select all

avantime — Wed, 15 Feb 2017 19:12:49 GMT

Hey Sunny, thanks for your advice, unfortunately I cannot select anything in the other sheet. Your example has the same issue

Re: LIST BOX - If none selected, select all

avantime — Wed, 15 Feb 2017 19:14:41 GMT

I don`t need to select the item, but if I do, the selection I asked at the beginning of this thread disappears. See Tresesco B`s reply.

Re: LIST BOX - If none selected, select all

avantime — Thu, 16 Feb 2017 10:56:30 GMT

solved it somehow.. I gave the other sheet an alternate state.