Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Highlighted
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
Highlighted
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?

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