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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!