Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

How to Filter rows in Table in Qlik Sense

Hi Everyone

This is my table

NameStatus
AActive
BInactive
CActive
DActive
EInactive

I need the result like this

NameStatus
AActive
CActive
DActive

I need to show only active employee.

1 Solution

Accepted Solutions

Re: How to Filter rows in Table in Qlik Sense

If you want to do this in front end then try below.

Create a Table chart.

Add dimension as Name

Add expression as MaxString({<Status = {"Active"}>}Status)

If you want to do this in script, try below.

Load Name, Status from xyz where Status = 'Active';

Regards,

Kaushik Solanki

6 Replies

Re: How to Filter rows in Table in Qlik Sense

If you want to do this in front end then try below.

Create a Table chart.

Add dimension as Name

Add expression as MaxString({<Status = {"Active"}>}Status)

If you want to do this in script, try below.

Load Name, Status from xyz where Status = 'Active';

Regards,

Kaushik Solanki

Shahzad_Ahsan
Contributor II

Re: How to Filter rows in Table in Qlik Sense

Hi Kaushik

I want to do on the front end only.

As you said, I have created a dimension

But when adding to chart, its showing invalid dimension

Why??

Re: How to Filter rows in Table in Qlik Sense

You have to ass it as expression(Measure) and not as dimension.

Regards,

Kaushik Solanki

Shahzad_Ahsan
Contributor II

Re: How to Filter rows in Table in Qlik Sense

Thank You Kaushik

This is working

Shahzad_Ahsan
Contributor II

Re: How to Filter rows in Table in Qlik Sense

After some research I found this is also working

If(Status='Active',Status,Null())

Re: How to Filter rows in Table in Qlik Sense

Good to know that you went ahead and found solution by your own..

Keep learning...


Regards,

Kaushik Solanki

Community Browser