Show Excluded

[reivax31]

Hi Qlikers,

I would like to display in a table the list of excluded values. Data looks like this:

Extract_Date	Project	Cat	Info
15/04/2018	A	1	A1
16/04/2018	A	1	A2
17/04/2018	A	1	A3
18/04/2018	A	1	A4
19/04/2018	A	1	A5
20/04/2018	A	1	A6
21/04/2018	A	2	A7
22/04/2018	A	2	A8
23/04/2018	A	2	A9
24/04/2018	A	2	A10
25/04/2018	A	2	A11
26/04/2018	A	2	A12
27/04/2018	A	2	A13
28/04/2018	A	2	A14
29/04/2018	A	2	A15
30/04/2018	A	2	A16
15/04/2018	B	1	B1
16/04/2018	B	1	B2
17/04/2018	B	1	B3
18/04/2018	B	1	B4
19/04/2018	B	1	B5
20/04/2018	B	1	B6
21/04/2018	B	1	B7
22/04/2018	B	1	B8
23/04/2018	B	1	B9
24/04/2018	B	1	B10
25/04/2018	B	1	B11
26/04/2018	B	1	B12
27/04/2018	B	1	B13
28/04/2018	B	1	B14
29/04/2018	B	1	B15
30/04/2018	B	1	B16

If I filter on Project = A, Cat=1 I get this:

Extract_Date	Project	Cat	Info
15/04/2018	A	1	A1
16/04/2018	A	1	A2
17/04/2018	A	1	A3
18/04/2018	A	1	A4
19/04/2018	A	1	A5
20/04/2018	A	1	A6

But what I would like to display is what is excluded:

21/04/2018	A	2	A7
22/04/2018	A	2	A8
23/04/2018	A	2	A9
24/04/2018	A	2	A10
25/04/2018	A	2	A11
26/04/2018	A	2	A12
27/04/2018	A	2	A13
28/04/2018	A	2	A14
29/04/2018	A	2	A15
30/04/2018	A	2	A16

How do I get this ?

Thanks for your help

[Chanty4u]

Hi

Sample attached

[passionate]

Try Using Select Excluded Trigger on Field

[reivax31]

Hi, sorry for the delay. I'm a Qlik Sense user and only manage .qvf

Could you send the expression or a qvf format?

Thanks for your support