topic Re: Show unselected items in QlikView

Show unselected items

Tue, 13 Nov 2012 14:31:52 GMT

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

Re: Show unselected items

Tue, 13 Nov 2012 14:34:39 GMT

Hi Graham,

Can u attach your sample application

Regards,

Ananth

Re: Show unselected items

Tue, 13 Nov 2012 14:53:13 GMT

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.

Re: Show unselected items

jeffmartins — Tue, 13 Nov 2012 14:53:57 GMT

Hi Graham Hodgson,

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

List Box Properties -> General -> Hide Excluded

Regards

Re: Show unselected items

Tue, 13 Nov 2012 15:04:42 GMT

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

Re: Show unselected items

Gysbert_Wassenaar — Tue, 13 Nov 2012 15:12:23 GMT

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

Re: Show unselected items

Tue, 13 Nov 2012 15:14:50 GMT

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

Re: Show unselected items

jeffmartins — Tue, 13 Nov 2012 15:25:12 GMT

Hi Graham Hodgson,

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

See the attached file.

Regards

Re: Show unselected items

Tue, 13 Nov 2012 15:38:53 GMT

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