Qlik Community

Qlik Sense App Development

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

theishovring
New Contributor

Set analysis combined with other filter

Hi

I have a table with columns using the following set analysis expression:

COUNT( {$ <PROCTYPE =-{''} >} SKSKODE )

PROCTYPE includes:

- Proc_A

- Proc_B

- etc.

AND

- NULL values, with I sort out using set analysis expression above.

I want my table to filter on for instance Proc_A, but the expression in my set analysis overrides the filter and my table shows all columns where PROCTYPE is not null not regarding the filter. Is it possible to only show for instance Proc_A without making another variable to use only in the set analysis expression?

Tags (2)
1 Solution

Accepted Solutions

Re: Set analysis combined with other filter

Try moving the negative sign in front of the equal sign

Count({$<PROCTYPE -= {''}>} SKSKODE)

1 Reply

Re: Set analysis combined with other filter

Try moving the negative sign in front of the equal sign

Count({$<PROCTYPE -= {''}>} SKSKODE)

Community Browser