Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator III
Creator III

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
Anil_Babu_Samineni

Like this may be?

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

And do suppress null value for dimension

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
New-Qlik
Creator III
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
New-Qlik
Creator III
Creator III
Author

I am trying to find where to do

Anil_Babu_Samineni

Please read below

Qlik Community Tip: Marking Replies as Correct or Helpful

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
New-Qlik
Creator III
Creator III
Author

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

Anil_Babu_Samineni

Let it be

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vinieme12
Champion III
Champion III

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)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.