Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculated dimensions

How do I only use certain records of my dimension field?  Example I have a field with (Hot, Cold, Warm) as the possible values.  I want to only have Hot and Cold as the ones that show up in my graph fot that dimension.

1 Solution

Accepted Solutions
MVP
MVP

Calculated dimensions

Maybe like

=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)

as calculated dimension, and check supress when Value is NULL in dimension tab.

4 Replies
MVP
MVP

Calculated dimensions

Maybe like

=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)

as calculated dimension, and check supress when Value is NULL in dimension tab.

Not applicable

Calculated dimensions

Thanks swuehl, as usual you got it!  Only thing is I'm still left with an empty spot in addition to the 'hot' and 'cold' field.  How would I suppress that?

Highlighted
MVP
MVP

Calculated dimensions

Have you checked the 'Suppress when Value is NULL' in dimension tab?

If so, how does your table look like? What do you mean with empty spot?

Not applicable

Calculated dimensions

Awwh swuehl!  A smart one you are!

Community Browser