Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

dimensions with condition

hi,

i have a straight table with two dimensions.

i want that the table will show only two values of one of the dimensions.

lets say-

my dimension 'country'

the values i want to show 'USA' 'israel'

i tried to put  in the enable condition: if(country='USA' or country='israel',1,0)

its not working.

can someone help me?!

12 Replies
stigchel
Partner - Master
Partner - Master

In general it is better to use the proposed set expression solution instead of the calculated dimension. It is better for the performance and you will not loose some of the dimension options (like sort). You will indeed have to include the set expression in all expressions (even some of the expessions as background color of the expression.)

Not applicable

Sum( {$<Country={'USA','Israel'}>} Sales)

hope answer the question.

adiarnon
Creator III
Creator III
Author

tnx everyone!!!