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: 
Not applicable

Calculated Dimension question - select only specific values

Hello,

I have a pivot table where Department is being used as a Dimension. Department has values such as 'Grocery', 'Frozen', 'Dairy', 'Meat', etc.

Instead of displaying all the dimension values, I want to display only 'Frozen' department. Could someone explain steps to do it? Thanks

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Probably the easiest way is to replace your "Department" dimension with a calculated dimension:

if("Department"='Frozen',"Department")

And then checkmark "Suppress When Value is Null" for that dimension. Another approach is to use set analysis in your expressions:

sum({<"Department"={'Frozen'}>} SomeField)

View solution in original post

2 Replies
johnw
Champion III
Champion III

Probably the easiest way is to replace your "Department" dimension with a calculated dimension:

if("Department"='Frozen',"Department")

And then checkmark "Suppress When Value is Null" for that dimension. Another approach is to use set analysis in your expressions:

sum({<"Department"={'Frozen'}>} SomeField)

Not applicable
Author

I tried first method before and it didn't work. But now I realized that departments names are all capital letters (Frozen != FROZEN) thats why I was getting the error.

Thanks for the response!