Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

frantzgnz
New Contributor II

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

Re: Show list of fields without using filter

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.

2 Replies
ishanbhatt
Contributor II

Re: Show list of fields without using filter

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.

frantzgnz
New Contributor II

Re: Show list of fields without using filter

Thanks Ishan! It works

Community Browser