topic Calculated dimensions in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341797#M577472 <HTML><HEAD></HEAD><BODY><P>Awwh swuehl!&nbsp; A smart one you are!</P></BODY></HTML> Wed, 07 Mar 2012 22:19:59 GMT 2012-03-07T22:19:59Z Calculated dimensions https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341793#M577468 <HTML><HEAD></HEAD><BODY><P>How do I only use certain records of my dimension field?&nbsp; Example I have a field with (Hot, Cold, Warm) as the possible values.&nbsp; I want to only have Hot and Cold as the ones that show up in my graph fot that dimension.</P></BODY></HTML> Wed, 07 Mar 2012 21:44:11 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341793#M577468 2012-03-07T21:44:11Z Calculated dimensions https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341794#M577469 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)</P><P></P><P>as calculated dimension, and check supress when Value is NULL in dimension tab.</P></BODY></HTML> Wed, 07 Mar 2012 22:04:30 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341794#M577469 swuehl 2012-03-07T22:04:30Z Calculated dimensions https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341795#M577470 <HTML><HEAD></HEAD><BODY><P>Thanks swuehl, as usual you got it!&nbsp; Only thing is I'm still left with an empty spot in addition to the 'hot' and 'cold' field.&nbsp; How would I suppress that?</P></BODY></HTML> Wed, 07 Mar 2012 22:16:04 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341795#M577470 2012-03-07T22:16:04Z Calculated dimensions https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341796#M577471 <HTML><HEAD></HEAD><BODY><P>Have you checked the 'Suppress when Value is NULL' in <EM>dimension</EM> tab?</P><P> If so, how does your table look like? What do you mean with empty spot?</P></BODY></HTML> Wed, 07 Mar 2012 22:18:39 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341796#M577471 swuehl 2012-03-07T22:18:39Z Calculated dimensions https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341797#M577472 <HTML><HEAD></HEAD><BODY><P>Awwh swuehl!&nbsp; A smart one you are!</P></BODY></HTML> Wed, 07 Mar 2012 22:19:59 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions/m-p/341797#M577472 2012-03-07T22:19:59Z