# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
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'

or better yet in your case

```If( Country = 'US', Country )
```
7 Replies
Honored Contributor II

## Re: Limit rows in Qliksense straight table

maybe this:

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

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'

or better yet in your case

```If( Country = 'US', Country )
```
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

Valued Contributor

## Re: Limit rows in Qliksense straight table

Why does he have to use Set Analysis?

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.

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)

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.