Discussion Board for collaboration related to QlikView App Development.
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
Probably the easiest way is to replace your "Department" dimension with a calculated dimension:
And then checkmark "Suppress When Value is Null" for that dimension. Another approach is to use set analysis in your expressions:
View solution in original post
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!