topic Re: Show non-selected Values in QlikView

Show non-selected Values

Tue, 10 Sep 2013 08:49:48 GMT

Is it possible to show in a sparaded list box all values which are not selected in the other?

swuehl — Tue, 10 Sep 2013 08:54:23 GMT

Should be possible, maybe like

=aggr( only( {<FIELD = e()>} FIELD) ,FIELD)

rbecher — Tue, 10 Sep 2013 08:59:48 GMT

Hi Hansjörg,

you can use an expression like this:

=aggr(only({1-$} Field), Field)

- Ralf

rbecher — Tue, 10 Sep 2013 09:03:58 GMT

..this is not working

swuehl — Tue, 10 Sep 2013 09:13:37 GMT

Yes, it's working at my site ...

It is showing all values, that were possible before making the selection in FIELD, except the selected values.

Using 11.2 SR3 64 bit

rbecher — Tue, 10 Sep 2013 10:08:09 GMT

It works only on my site if no other field has a slection..

swuehl — Tue, 10 Sep 2013 16:40:02 GMT

No, I do get a result also with values selected in other fields.

But there is a difference between our two expressions, of course.

I've created a little example to show the difference.