This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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, ProductA, 1A, 2A, 3B, 3B, 4B, 5];
Load Product,1 as Key Resident TT where Customer = 'A';
Hope This Helps.
View solution in original post
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.
I would like to filter out all the products that have been ordered only by Customer B, not anyone else.
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.
Thank you so much for the detailed answer!