topic Re: calculated dimension if and in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592515#M680255 <HTML><HEAD></HEAD><BODY><P>Can you provide sample data or sample apps?</P></BODY></HTML> Wed, 02 Apr 2014 15:57:39 GMT MK_QSL 2014-04-02T15:57:39Z calculated dimension if and https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592512#M680252 <HTML><HEAD></HEAD><BODY><P>Why this works for a field in a listbox and not for a calculated dimmension in a pivot table</P><P></P><P>=if(left(conta_id,2)='92'and Len(conta_id)=4,conta_id)</P><P></P><P>thank you for your time</P></BODY></HTML> Wed, 02 Apr 2014 15:05:00 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592512#M680252 2014-04-02T15:05:00Z Re: calculated dimension if and https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592513#M680253 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=IF(Left(conta_id,2) = 92 and Len(conta_id)=4, conta_id)</P></BODY></HTML> Wed, 02 Apr 2014 15:09:30 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592513#M680253 MK_QSL 2014-04-02T15:09:30Z Re: calculated dimension if and https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592514#M680254 <HTML><HEAD></HEAD><BODY><P>thank you but didn´t work</P></BODY></HTML> Wed, 02 Apr 2014 15:54:12 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592514#M680254 2014-04-02T15:54:12Z Re: calculated dimension if and https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592515#M680255 <HTML><HEAD></HEAD><BODY><P>Can you provide sample data or sample apps?</P></BODY></HTML> Wed, 02 Apr 2014 15:57:39 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592515#M680255 MK_QSL 2014-04-02T15:57:39Z Re: calculated dimension if and https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592516#M680256 <HTML><HEAD></HEAD><BODY><P>Try adding the code to your script and create a new field</P><P></P><P>Richard</P><P>QlikCentral.com</P></BODY></HTML> Wed, 02 Apr 2014 15:59:10 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-if-and/m-p/592516#M680256 richard_pearce6 2014-04-02T15:59:10Z