Exclude value from listbox

[shiveshsingh]

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)

[swuehl]

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.

[shiveshsingh]

it is coming like this, keen is still visible

[swuehl]

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

[qlikview979]

Hi

Are you Expecting like this

[vinieme12]

Try

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

or

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

[shiveshsingh]

done thanks