Filter on rows in table - Qlik Sense

[RutiTaumanRubin]

Hello,

I create new table only with columns (no measure).

I want to display only the rows that their field "Active"=Y.

Could you please advise how to do it?

Thank's!!

[jaumecf23 · Accepted solution]

You can create your own dimension, something like this:

=if(Active='Y', DimensionName)

[sravan_v007]

Create a calculated dimension in the Master items  and add that dimension to your table and use supress null to exclude other  field values.

  Ex: Backend data table

Name	Active	Dep
A	Y	Hr
B	Y	Finance
C	N	Risk
D	N	Operations

Front end: If you get null values, use suppress null to exclude null.

if(Active='Y', Name)	Dep
A	Hr
B	Finance
-	Risk
-	Operations