Include few values form a dimension

[New-Qlik]

Hello everyone

I have a requirement in which I want to include only few dim values example

Country

A

B

C

D

E

F

G

h etc

iw nat to see bar chart to show data for just A,B ,D,F,G H

I USED THIS IN DIM

if(country = 'A','B' ,'D','F','G', 'H'), country, '')

it didn't  work. Kindly Guide

[Anil_Babu_Samineni]

Like this may be?

if(Match(country, 'A','B' ,'D','F','G', 'H'), country)

And do suppress null value for dimension

[New-Qlik]

thanks alot.. how can I forgett match u saved me

[Anil_Babu_Samineni]

Could be, And if you got answer please flag the Correct answer

[New-Qlik]

I am trying to find where to do

[Anil_Babu_Samineni]

Please read below

Qlik Community Tip: Marking Replies as Correct or Helpful

[New-Qlik]

I know this anil but that star symbol with correct is not coming somehow. I am sorry

[Anil_Babu_Samineni]

Let it be

[vinieme12]

you should ideally be restricting the values using Set Analysis in the Expression

example

Dimension = Country

Expression = SUM({<Country={'A','B' ,'D','F','G', 'H'}>}Sales)