Restrict/filter out rows in a table (Qliksense) based on the condition

[manojkumargowda]

Hi Guys,

What is the best way to filter out rows in the Qliksense table. e.g. I need to have data only for active employees. In qlikview, we can create a dummy measure (sum({<active={'Y'}>}1)) and we can hide this dummy column. This works in qlikview. But Qliksense, If we hide the dummy measure, corresponding filter also vanishes.

Please tell me how can we restrict/filter rows in Qliksense table.

Note: I have only dimensions in the table and no extra columns should appear in the dashboard.

[pradosh_thakur]

try this

if(active='Y',dimension,null())

then suppress null