Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this may be?
if(Match(country, 'A','B' ,'D','F','G', 'H'), country)
And do suppress null value for dimension
thanks alot.. how can I forgett match u saved me
Could be, And if you got answer please flag the Correct answer
I am trying to find where to do
Please read below
Qlik Community Tip: Marking Replies as Correct or Helpful
I know this anil but that star symbol with correct is not coming somehow. I am sorry
Let it be
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)