Show non-selected Values - Qlik Community

Report Inappropriate Content · ‎2013-09-10

Hi

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

swuehl · ‎2013-09-10

Should be possible, maybe like

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

rbecher · ‎2013-09-10

Hi Hansjörg,

you can use an expression like this:

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

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

rbecher · ‎2013-09-10

..this is not working

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

swuehl · ‎2013-09-10

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 · ‎2013-09-10

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

swuehl · ‎2013-09-10

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.