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: 
reivax31
Partner - Creator III
Partner - Creator III

Show Excluded

Hi Qlikers,

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

  

Extract_DateProjectCatInfo
15/04/2018A1A1
16/04/2018A1A2
17/04/2018A1A3
18/04/2018A1A4
19/04/2018A1A5
20/04/2018A1A6
21/04/2018A2A7
22/04/2018A2A8
23/04/2018A2A9
24/04/2018A2A10
25/04/2018A2A11
26/04/2018A2A12
27/04/2018A2A13
28/04/2018A2A14
29/04/2018A2A15
30/04/2018A2A16
15/04/2018B1B1
16/04/2018B1B2
17/04/2018B1B3
18/04/2018B1B4
19/04/2018B1B5
20/04/2018B1B6
21/04/2018B1B7
22/04/2018B1B8
23/04/2018B1B9
24/04/2018B1B10
25/04/2018B1B11
26/04/2018B1B12
27/04/2018B1B13
28/04/2018B1B14
29/04/2018B1B15
30/04/2018B1B16

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

  

Extract_DateProjectCatInfo
15/04/2018A1A1
16/04/2018A1A2
17/04/2018A1A3
18/04/2018A1A4
19/04/2018A1A5
20/04/2018A1

A6

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

  

21/04/2018A2A7
22/04/2018A2A8
23/04/2018A2A9
24/04/2018A2A10
25/04/2018A2A11
26/04/2018A2A12
27/04/2018A2A13
28/04/2018A2A14
29/04/2018A2A15
30/04/2018A2A16

 

How do I get this ?

Thanks for your help

3 Replies
Chanty4u
MVP
MVP

Hi

Sample attached

passionate
Specialist
Specialist

Try Using Select Excluded Trigger on Field

reivax31
Partner - Creator III
Partner - Creator III
Author

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