topic Calculated Dimensions in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341765#M126238 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">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.</SPAN></P></BODY></HTML> Wed, 07 Mar 2012 22:02:46 GMT 2012-03-07T22:02:46Z Calculated Dimensions https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341765#M126238 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">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.</SPAN></P></BODY></HTML> Wed, 07 Mar 2012 22:02:46 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341765#M126238 2012-03-07T22:02:46Z Calculated Dimensions https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341766#M126239 <HTML><HEAD></HEAD><BODY><P>Hi Brandon,</P><P></P><P>just try function:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; ValueList('Hot', 'Cold')</P><P></P><P>as a calculated dimension.</P><P></P><P>- Ralf</P></BODY></HTML> Wed, 07 Mar 2012 22:11:45 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341766#M126239 rbecher 2012-03-07T22:11:45Z Re: Calculated Dimensions https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341767#M126240 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)</P><P></P><P>edit:</P><P></P><P>Oh, I just thought I have already answered the question but forgot to commit <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Wed, 07 Mar 2012 22:14:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimensions/m-p/341767#M126240 swuehl 2012-03-07T22:14:32Z