topic Re: Show Excluded Values in QlikView

Show Excluded Values

Tue, 24 Mar 2015 16:31:42 GMT

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.

Re: Show Excluded Values

awhitfield — Tue, 24 Mar 2015 16:46:05 GMT

HI Andrew,

can you post an example app?

Andy

Re: Show Excluded Values

richard_chilvers — Tue, 24 Mar 2015 16:58:11 GMT

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)

Re: Show Excluded Values

Tue, 24 Mar 2015 16:58:26 GMT

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 !

Re: Show Excluded Values

giakoum — Tue, 24 Mar 2015 17:00:52 GMT

see attached

Re: Show Excluded Values

maxgro — Tue, 24 Mar 2015 17:01:51 GMT

try with this expression in listbox

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

Re: Show Excluded Values

Tue, 24 Mar 2015 17:12:34 GMT

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!