topic Re: Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204014#M387174 <HTML><HEAD></HEAD><BODY><P>Yes you can,</P><P>But CD are expensive - is better to use your criteria with Set Analysis</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P></BODY></HTML> Tue, 01 Nov 2016 21:13:38 GMT robert_mika 2016-11-01T21:13:38Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204011#M387171 <HTML><HEAD></HEAD><BODY><P>I would like to create a calculated dimension for a table.</P><P>My field is 'transBUYERTPE' and within that field that are several types of buyer types, such as ADULT, STH</P><P></P><P>What is the syntax for a calculated dimension to focus in on, for example. a transBUYERTYPE of ADULT?</P></BODY></HTML> Tue, 01 Nov 2016 20:15:51 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204011#M387171 evansabres 2016-11-01T20:15:51Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204012#M387172 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>=if(transBUYERTYPE ='ADULT',transBUYERTYPE)</P><P></P><P>the tick the box next to 'Suppress When Value is Null' from</P><P>'Setting For Selected Dimension'</P></BODY></HTML> Tue, 01 Nov 2016 20:29:46 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204012#M387172 robert_mika 2016-11-01T20:29:46Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204013#M387173 <HTML><HEAD></HEAD><BODY><P>This works perfectly, thank you. Is it possible to have multiple calculated dimensions?</P></BODY></HTML> Tue, 01 Nov 2016 20:34:34 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204013#M387173 evansabres 2016-11-01T20:34:34Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204014#M387174 <HTML><HEAD></HEAD><BODY><P>Yes you can,</P><P>But CD are expensive - is better to use your criteria with Set Analysis</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P></BODY></HTML> Tue, 01 Nov 2016 21:13:38 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1204014#M387174 robert_mika 2016-11-01T21:13:38Z