Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter to show those not in the listbox

Hi all,

Right now I can only click on one of the values in the listbox.

How do I filter to show data that are not found in the listbox? So if my listbox looks like this:

Field1

A

B

C

I would like my other table box to show data whose Field1 is not A, nor B nor C.

Thanks in advance.

7 Replies
Not applicable
Author

Hi,

You can use set analysis for the mentioned task

whiteline
Master II
Master II

By 'not found' do you mean the data where Field1 is null ?

Not applicable
Author

HI Rajamani,

Where can I find this set analysis?

Thanks

Not applicable
Author

Hi all,

Here is a simplified sample data to illustrate my question.

I have the 2 tables below:

Table1.JPG

Table2.JPG

I loaded both by going to EDIT SCRIPT, TABLE files.

Now in my qlikview worksheet, I have the following list box:

Listbox.JPG

and the below tablebox:

Tablebox.JPG

I would like that the tablebox to show those that are not found i.e. Found <> "Yes".

The expected outcome is for the tablebox to show File3 / D

I tried selecting the YES in the found listbox and right click and SELECT EXCLUDED, but this resulted to all Filenames/Voucher showing up.

Thanks in advance for your help.

whiteline
Master II
Master II

You can't do it that way. In other words you can't select 'nothing' (Only in calculations with set analysis).

You should add 'Field3' with 'No' into your second table.

Not applicable
Author

Try to have an output chart with chart type as straight table

Dimension:

FileName

VoucherNumber

=if(Found <> GetFieldSelections(Found),(Found))

Expressions:

Dummy

Not applicable
Author

Hi patsys50,

in the multibox you can add a formula as field. With this set analysis you can easly filter out data.