Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

reivax31
Contributor 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

Tags (1)
3 Replies
sureshqv
Esteemed Contributor III

Re: Show Excluded

Hi

Sample attached

passionate
Valued Contributor

Re: Show Excluded

Try Using Select Excluded Trigger on Field

reivax31
Contributor III

Re: Show Excluded

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

Community Browser