topic Re: Select Excluded as Default on List Box in QlikView

Select Excluded as Default on List Box

Tue, 16 Jun 2015 22:53:58 GMT

Is there a way to make "Select Excluded" the default for one specific list box?

Re: Select Excluded as Default on List Box

ramoncova06 — Wed, 17 Jun 2015 15:27:40 GMT

not sure I understand what you are asking for

if I have a default selection wouldn't that make the values left out the excluded ones ?

if you could provide more details

Re: Select Excluded as Default on List Box

Wed, 17 Jun 2015 15:30:26 GMT

Basically I want the Current Selections to equal the inverse of what is selected in the List Box.

Re: Select Excluded as Default on List Box

Anonymous — Wed, 17 Jun 2015 15:45:25 GMT

Try putting this expression into a Text Object :

= concat ( {<YourField=E(YourField)>} YourField, ', ')

Does that give you food for thought ?

Re: Select Excluded as Default on List Box

ramoncova06 — Wed, 17 Jun 2015 15:45:44 GMT

you could probably do it with alternate states and triggers

Re: Select Excluded as Default on List Box

Wed, 17 Jun 2015 16:05:17 GMT

I didn't get any results?

Re: Select Excluded as Default on List Box

Anonymous — Wed, 17 Jun 2015 16:06:58 GMT

Can you post a sample qvw ?

Re: Select Excluded as Default on List Box

Wed, 17 Jun 2015 18:37:04 GMT

When selecting a value in the Exclude Cure Status List Box on the Filters tab, instead of including the value in the Current Selections, I want to exclude it.

Thanks!

Re: Select Excluded as Default on List Box

Anonymous — Thu, 18 Jun 2015 12:42:44 GMT

Laura

Have a look at the attached.

I have created 2 new variables :

vExclude = concat( {$*EState} distinct '"' & $(='[Cure Status]') & '"' ,',' )

vSetExclude = '{< [Cure Status] = E({<[Cure Status]={$(vExclude)}>} [Cure Status] ) >}'

And added a new Alternate State: EState

And set the existing Exclude Cure Status List box to use this State EState

And added a test Straight Table State $, with Expression

count ( $(vSetExclude) [Cure Status] )

This should, I hope, only show Cure Status where it has been excluded via the Exclude Cure Status List box.

In your real objects similar set analysis via the variable vSetExclude will need adding.

Also have a look at this blog post that gives an explanation and an example, albeit the example has other things irrelevant to your question.

www.infinityinsight.com/blog/?p=270