topic Re: Exclude values in listbox in QlikView

Exclude values in listbox

tom2013 — Tue, 02 Apr 2019 13:54:20 GMT

Hi all,

I wonder if there's a way to select the values in a field that belongs exclusively to a value in another field by using list box.

A simple example to make it clear:

From the table below I would like to filter out all the products that have only been ordered by customer B, and not by A.

So if I select value A and B in Customer field first, can I exclude all the products that has been ordered by A (001-003), so only product ordered by B (004) will be selected.

Thank you in advance.

Customer Product

A 001

A 002

A 003

B 003

B 004

Re: Exclude values in listbox

ashok_rajm — Tue, 02 Apr 2019 13:16:23 GMT

Do you want to exclude in backend or in front end.. Can you specify more details and what results you are looking for..

Re: Exclude values in listbox

tom2013 — Tue, 02 Apr 2019 13:35:57 GMT

Thank you for your reply, I have updated the question description. I want to know if this could be done in front end by using list box, so I can get the desired data range for my chart.

Re: Exclude values in listbox

ashok_rajm — Tue, 02 Apr 2019 13:47:47 GMT

Incase if you have Customer A,B,C and if you select A, B & C together. what results you would need.

Re: Exclude values in listbox

tom2013 — Tue, 02 Apr 2019 13:52:55 GMT

I would like to filter out all the products that have been ordered only by Customer B, not anyone else.

Re: Exclude values in listbox

ashok_rajm — Wed, 03 Apr 2019 09:44:35 GMT

So what i understood is, if you Select A & B, You need only Product 4 to be shown in the Product list box as 4 is the only Unique Product from B.

Re: Exclude values in listbox

tom2013 — Thu, 04 Apr 2019 06:40:55 GMT

Yes exactly

Re: Exclude values in listbox

ashok_rajm — Fri, 05 Apr 2019 08:29:11 GMT

Ok.. I think you con't directly achieve this in Front end, because there is no any key which says this unique value.

I was able to create it with back-end and front-end.

Listbox expression: = if(GetSelectedCount(Customer)>0,if(WildMatch(Customer, '*B*') and Key <> 1 ,Product),Product)

And back-end you need to create a flag for each unique values for B:

TT:
LOAD * INLINE [
Customer, Product
A, 1
A, 2
A, 3
B, 3
B, 4
B, 5
];

Load Product,1 as Key Resident TT where Customer = 'A';

Hope This Helps.

Re: Exclude values in listbox

tom2013 — Thu, 11 Apr 2019 14:32:46 GMT

Hi Ashok,

Thank you so much for the detailed answer!