Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
manojkumargowda
Contributor

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

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.

1 Reply
pradosh_thakur
Honored Contributor II

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

try this

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

then suppress null
Learning never stops.