Show unselected items

[#1]

Hi all,

I've got a problem, but I'm not sure exactly how to search for an existing solution, so apologies if I'm recreating the wheel...

Imagine a field called SalesPeople:

John

Dave

Mike

Paula

Luke

Fred

Claire

I have a selection box where I choose a region. This cuts the list down to:

John

Dave

Mike

Luke

I select a product that I'm interested in being sold. Only John and Mike sold this product, which I can show. But how do I show Dave and Luke, ie. those that aren't in the selection? Any ideas?

Cheers

Graham

[#2]

Hi Graham,

Can u attach your sample application

Regards,

Ananth

[#3]

Attached is a simple example. Just to clarify, I'd like to be able to export to Excel the SalesPerson list that haven't sold WidgetA from the North Region.

[jeffmartins]

Hi Graham Hodgson,

Have you checked if the "Hide Excluded" option is checked ?

List Box Properties -> General -> Hide Excluded

Regards

[#5]

Hi Jeff,

Not sure if I'm missing something there? That just seems to hide the salespeople that haven't sold WidgetB or are in the South??

Cheers

Graham

[Gysbert_Wassenaar]

It can be done with a macro. I haven't found another way to do this yet. See attached qvw.

[#7]

Hi Graham

In Sales Person list box

right click -- click select excluded

i will display who not sot sold  Widget B names

I think your doubt is clear

Regardss,

Ananth

[jeffmartins · Accepted solution]

Hi Graham Hodgson,

You can create a list with the excluded values using an expression in the list.

See the attached file.

Regards

[#9]

Hi all,

Thanks for all your suggestions! I've also found this http://community.qlik.com/message/168090#168090 as a link on the right hand side of this thread. The expression

=ONLY({<SalesPerson=e(SalesPerson), SKU= >}SalesPerson)

also seems to work, if a little kludgy in a table.

Cheers

Graham