Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manojkumargowda
New Contributor III

Limit rows in Qliksense straight table

Hello,

I need to limit rows in Qliksense straight table by giving country filter. We have many countries data in that table, But I need to show only US (i.e. where country='US') data in the straight table.  Can someone please suggest how to achieve this ?

1 Solution

Accepted Solutions
JustinDallas
Valued Contributor

Re: Limit rows in Qliksense straight table

In one of your dimensions, have something like this

If( [Driver Is Active] = 'N', [Driver Id] )

And then you uncheck the box labeled "Include null values'

HideNullValues.PNG

or better yet in your case

If( Country = 'US', Country )

7 Replies
agigliotti
Honored Contributor II

Re: Limit rows in Qliksense straight table

maybe this:

sum( {< country = {'US'} >} your_measure )

JustinDallas
Valued Contributor

Re: Limit rows in Qliksense straight table

In one of your dimensions, have something like this

If( [Driver Is Active] = 'N', [Driver Id] )

And then you uncheck the box labeled "Include null values'

HideNullValues.PNG

or better yet in your case

If( Country = 'US', Country )

jmvilaplanap
Valued Contributor

Re: Limit rows in Qliksense straight table

Hi,

If you want to filter a table, you must use "Set Analysis":

Function({<Country={'US'}>} measure)

Cheers

JustinDallas
Valued Contributor

Re: Limit rows in Qliksense straight table

Why does he have to use Set Analysis?

jmvilaplanap
Valued Contributor

Re: Limit rows in Qliksense straight table

Because is more efficient than use an if statement.

IF Vs Set Analysis

If you want to filter a table without user intervention, use Set Analysis is the best way.

sunilkumarqv
Valued Contributor II

Re: Limit rows in Qliksense straight table

Create a calculated dimension

if(Country='US',Country)

or

in expression use in set analysis

for examples

= sum({<country={'US'}>} sales)

manojkumargowda
New Contributor III

Re: Limit rows in Qliksense straight table

Thanks all for the response.

I'm not using any measures in the straight table, just few dimensions. So I have to use If condition.

Community Browser