Discussion board where members can get started with QlikView.
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:
I would like my other table box to show data whose Field1 is not A, nor B nor C.
Thanks in advance.
You can use set analysis for the mentioned task
By 'not found' do you mean the data where Field1 is null ?
Where can I find this set analysis?
Here is a simplified sample data to illustrate my question.
I have the 2 tables below:
I loaded both by going to EDIT SCRIPT, TABLE files.
Now in my qlikview worksheet, I have the following list box:
and the below tablebox:
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.
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.
Try to have an output chart with chart type as straight table
=if(Found <> GetFieldSelections(Found),(Found))
in the multibox you can add a formula as field. With this set analysis you can easly filter out data.