Function / Method to Filter a list of Value in a dimension in Straight table

[#1]

Is there a way to to Hide / Filter a specific Value in the straight table dimension.

Ex:

Country

USA

UK

France

Canada

Japan

and I want to filter the Value say (Japan) from the straight table.

Best -

SA

[manas_bn]

Hello,

A crude method I can think of:

Add a calculated dimension

=if(not match(Country,'Japan'),Country)

Suppress Null values in dimensions

Cheers!

[#3 · Accepted solution]

Try this for your dimension.

if(Country<>Japan,Country)

[jagan]

Hi,

Instead of going for Calculated Dimension since Calculated Dimension leads to performance issues, you can do the same in Expression like this

=Sum({<Country-={'Japan'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[#5]

hi

you can use calculated dimention :if(country<>'japan',country).

[#6]

Hi Jagan -

I am trying the exact Expression, It works for "=",, But doesn't work for "<>".

Any Idea for NOT EQUAL Sign in to define Here.

Example :

=Sum({$<Country = {'Japan','France'}>}Revenue)  ----- Works

=Sum({$<Country <> {'Japan','France'}>}Revenue)  --------  Doesn't Work

=Sum({$<Country -= {'Japan','France'}>}Revenue)  --------   Doesn't Work

=Sum({$<Country != {'Japan','France'}>}Revenue)  --------   Doesn't Work

Is there a specific Syntax for NOT EQUAL in QV Set Analysis

[#7]

Thanks -

This Works!

=IF(Country<>'Japan',Country)  and I have suppressed the Null Values.

[#8]

Thanks -

This Works,

The Code Below:

=If(NOT MATCH(Country,'Japan','France'),Country)

[#9]

=If(NOT MATCH(Country,'Japan','France'),Country)  ---- This Works

[jagan]

Hi Syed,

This would definitely work, Qlikview shows as error (underlined red color) but it works.  Please check.

=Sum({<Country -= {'Japan','France'}>}Revenue)

Regards,

Jagan.