Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jcarloscandela
New Contributor II

How to filter rows on a table

Hello,

I'm a bit newbie and I'm trying to filter a table, taking only the rows when NPS > NPSb

Captura.PNG

I only want to show these rows

2.png

Which is the best way to do it without modify the Load Script?, Should I create a Calculated Dimension? or Is it better to use a measure? 

Ty

Labels (2)
1 Solution

Accepted Solutions
VishalWaghole
Valued Contributor II

Re: How to filter rows on a table

Creating only one expression as below,

If(sum(NPS)>sum(NPSb), sum(NPS))

Regards,
Vishal
3 Replies
VishalWaghole
Valued Contributor II

Re: How to filter rows on a table

Creating only one expression as below,

If(sum(NPS)>sum(NPSb), sum(NPS))

Regards,
Vishal
jcarloscandela
New Contributor II

Re: How to filter rows on a table

I tryed it before, but I want to hide the Null values, It is possible to hide null values in a expression?

VishalWaghole
Valued Contributor II

Re: How to filter rows on a table

Go to chart proprties, under both dimensions you will get option as Include null values, just uncheck it.

Hope this will work for you.

Regards,
Vishal