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: 
Anonymous
Not applicable

Show list of fields without using filter

Hello! I have a doubt.

I have a field called 'Problema'. This is a text field. I show you here:

Problema.png

There is another field called 'Estado', that shows 'Open' or 'Closed'.

I want to show just Fields who are 'Open' , without a filter. I think I have to use Set Analisys, But I don't know the expression.

I only have to use Year and Month Filter. Now, It shows me all the fields that are from the year and month respectfully.

All.png

But I just want to show these 7 fields:

Estado.png

1 Solution

Accepted Solutions
ishanbhatt
Creator II
Creator II

Hi Frantz,

In your case, you can apply IF condition in the dimension.

Something like this,

=if(Estado='open',Estado)

and uncheck the Include null values option.

I've also attached example app. Hopefully, this will help you.

View solution in original post

2 Replies
ishanbhatt
Creator II
Creator II

Hi Frantz,

In your case, you can apply IF condition in the dimension.

Something like this,

=if(Estado='open',Estado)

and uncheck the Include null values option.

I've also attached example app. Hopefully, this will help you.

Anonymous
Not applicable
Author

Thanks Ishan! It works