Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select Excluded as Default on List Box

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

8 Replies
ramoncova06
Specialist III
Specialist III

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

Not applicable
Author

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

Anonymous
Not applicable
Author

Try putting this expression into a Text Object :

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

Does that give you food for thought ?

ramoncova06
Specialist III
Specialist III

you could probably do it with alternate states and triggers

Not applicable
Author

I didn't get any results?

Anonymous
Not applicable
Author

Can you post a sample qvw ?

Not applicable
Author

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!

Anonymous
Not applicable
Author

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