Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Include few values form a dimension

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

8 Replies
Highlighted

Like this may be?

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

And do suppress null value for dimension

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

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

Highlighted

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

I am trying to find where to do

Highlighted

Please read below

Qlik Community Tip: Marking Replies as Correct or Helpful

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

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

Highlighted

Let it be

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Champion II
Champion II

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)