Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

try with this expression in listbox

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

View solution in original post

6 Replies
Highlighted
Partner
Partner

HI Andrew,

can you post an example app?

Andy

Highlighted
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)

Highlighted
Not applicable

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 !

Highlighted
Partner
Partner

see attached

Highlighted
MVP
MVP

try with this expression in listbox

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

View solution in original post

Highlighted
Not applicable

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!