Limit rows in Qliksense straight table

[manojkumargowda]

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 ?

[agigliotti]

maybe this:

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

[JustinDallas · Accepted solution]

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 )

[jmvilaplanap]

Hi,

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

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

Cheers

[JustinDallas]

Why does he have to use Set Analysis?

[jmvilaplanap]

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]

Create a calculated dimension

if(Country='US',Country)

or

in expression use in set analysis

for examples

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

[manojkumargowda]

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.