Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

how to ignore one country sale in straight table?

Hi ,

I have straight table that consist country as dimension, in that i don't want to show one country how can we do please help me .

Thanking you

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: how to ignore one country sale in straight table?

SUM({<Country -= {'CountryName'}>}Sales)

View solution in original post

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: how to ignore one country sale in straight table?

You could exclude this country within the dimension per: if(Country = 'x', null(), Country) and hiding NULL's within the dimension or also with a set analysis condition within the expression like: sum({< Country -= {'x'}>} Value).

- Marcus

Highlighted
MVP
MVP

Re: how to ignore one country sale in straight table?

SUM({<Country -= {'CountryName'}>}Sales)

View solution in original post

Highlighted
Contributor

Re: how to ignore one country sale in straight table?

thank you Marcus Sommer it's working

Highlighted
Contributor

Re: how to ignore one country sale in straight table?

thank you

Highlighted
New Contributor III

Re: how to ignore one country sale in straight table?

Hi,

Try below.

In the straight table go to Properties  -> Dimensions --> 'Add Calculated Dimension' --> add the expression

If(Not Match(country,'Canada'),Country) --  It will show all the countries except Canada. Also check 'Suppress when value is null'.

Look at the screenshot below.

table.JPG