topic Re: Exclude value from listbox in QlikView

Exclude value from listbox

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

i have 2 value in listbox.

Steve, keen

How to show listbox by excluding 1 value?

below expression in listbox is not working.

if(Owner = 'Steve',Owner)

Re: Exclude value from listbox

swuehl — Sat, 13 May 2017 09:42:29 GMT

It should work as you have written, but take care to input the expression in the field <expression> (from field drop down on general tab),not on expression tab.

Re: Exclude value from listbox

shiveshsingh — Sat, 13 May 2017 09:49:04 GMT

it is coming like this, keen is still visible

Re: Exclude value from listbox

swuehl — Sat, 13 May 2017 09:52:12 GMT

As I said, you need to enter the expression on general tab, like a calculated dimension, not a measure:

Re: Exclude value from listbox

qlikview979 — Sat, 13 May 2017 09:52:25 GMT

Are you Expecting like this

Re: Exclude value from listbox

vinieme12 — Sat, 13 May 2017 10:15:45 GMT

Try

=AGGR(if(Owner = 'Steve',Owner),Owner)

=AGGR( Only ({<Owner ={'Steve'}>} Owner) , Owner)

Re: Exclude value from listbox

shiveshsingh — Sat, 13 May 2017 10:22:45 GMT

done thanks