topic Calculated Dimension question - select only specific values in QlikView

Calculated Dimension question - select only specific values

Tue, 30 Mar 2010 18:23:00 GMT

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

Calculated Dimension question - select only specific values

johnw — Tue, 30 Mar 2010 19:30:53 GMT

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)

Calculated Dimension question - select only specific values

Tue, 30 Mar 2010 19:45:49 GMT

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!