Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Filter to show those not in the listbox

Hi,

You can use set analysis for the mentioned task

whiteline
Honored Contributor II

Re: Filter to show those not in the listbox

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

Not applicable

Re: Filter to show those not in the listbox

HI Rajamani,

Where can I find this set analysis?

Thanks

Not applicable

Re: Filter to show those not in the listbox

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
Honored Contributor II

Re: Filter to show those not in the listbox

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

Re: Filter to show those not in the listbox

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

Dimension:

FileName

VoucherNumber

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

Expressions:

Dummy

Not applicable

Re: Filter to show those not in the listbox

Hi patsys50,

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


Community Browser