Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Filter on rows in table - Qlik Sense

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!!

1 Solution

Accepted Solutions
jaumecf23
Creator III
Creator III

You can create your own dimension, something like this:

=if(Active='Y', DimensionName)

View solution in original post

2 Replies
jaumecf23
Creator III
Creator III

You can create your own dimension, something like this:

=if(Active='Y', DimensionName)

View solution in original post

sravan_v007
Partner
Partner

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

   

NameActiveDep
AYHr
BYFinance
CNRisk
DNOperations

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

   

if(Active='Y', Name)Dep
AHr
BFinance
-Risk
-Operations