Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Highlighted
MVP
MVP

Calculated Dimension question - select only specific values

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
Highlighted
MVP
MVP

Calculated Dimension question - select only specific values

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

Highlighted
Not applicable

Calculated Dimension question - select only specific values

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!