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

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

manojkumargowda — Tue, 22 Jan 2019 07:06:49 GMT

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.

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

pradosh_thakur — Tue, 22 Jan 2019 07:12:03 GMT

try this

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

then suppress null

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

fabdulazeez — Tue, 14 May 2024 11:11:08 GMT

"Have you managed to find any method to achieve the same?