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

Show Excluded Values

Hi everyone,

Can I create a list box or other object that lists all excluded values in a dimension?

I want to create a functionality where the user selects a [Company], and a list box shows all related [Orders]. Then, when he selects some orders, the other excluded orders will appear in a second list box. Ideally, the user would then be able to add some of the excluded orders back into the selection, and have the list update.

Any guesses? Thanks.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with this expression in listbox

=aggr(Only({$ <Order=E(Order)>} Order), Order)

View solution in original post

6 Replies
awhitfield
Partner - Champion
Partner - Champion

HI Andrew,

can you post an example app?

Andy

richard_chilvers
Specialist
Specialist

Hi Andrew

You could have a second list box with the following expression; it seems to work but is not very elegant !

=

IF(NOT GetFieldSelections(Orders)=Orders,Orders)

Not applicable
Author

Sure Andy, although not sure if it will be helpful.

In this app, I have selected Company 'A'. I then have Contracts 'v' and 'w' available to select.

If I select 'v', I would like contract 'w' (the excluded value within set Company='A), to be listed separately somewhere.

Ideally in addition, the user could then select 'w' again to have it returned to the selection.

Best,

Andrew !

giakoum
Partner - Master II
Partner - Master II

see attached

maxgro
MVP
MVP

try with this expression in listbox

=aggr(Only({$ <Order=E(Order)>} Order), Order)

Not applicable
Author

Awesome, awesome, thank you all! All your responses were correct, but I gave the correct answer to Massimo, because his solution very cleverly only shows those selections excluded within Company 'A'.

Thanks!