topic Re: Calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/336747#M124160 <HTML><HEAD></HEAD><BODY><P>sorry when posting it becomes line 3-5</P></BODY></HTML> Fri, 03 Aug 2012 08:59:05 GMT 2012-08-03T08:59:05Z Calculated dimension https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/336746#M124159 <HTML><HEAD></HEAD><BODY><P>Can anybody help with this problem. I'm trying sp group customer into 3 categories based on revenue. i've made the following statement which works fine in expression, but won't work as a calculated dimension. </P><P></P><P>=If(Sum(if(CUSTOMER.CGRNO &lt;&gt; 'IA' And CUSTOMER.CGRNO &lt;&gt; 'KA' And CUSTOMER.CGRNO &lt;&gt; 'BA',&nbsp; New_NET)) &gt;= '90000', 'A',</P><P>if(Sum(if(CUSTOMER.CGRNO &lt;&gt; 'IA' And CUSTOMER.CGRNO &lt;&gt; 'KA' And CUSTOMER.CGRNO &lt;&gt; 'BA',&nbsp; New_NET)) &gt;= '30000' And Sum(if(CUSTOMER.CGRNO &lt;&gt; 'IA' And CUSTOMER.CGRNO &lt;&gt; 'KA' And CUSTOMER.CGRNO &lt;&gt; 'BA',&nbsp; New_NET)) &lt; '90000', 'B', </P><P>if(Sum(if(CUSTOMER.CGRNO &lt;&gt; 'IA' And CUSTOMER.CGRNO &lt;&gt; 'KA' And CUSTOMER.CGRNO &lt;&gt; 'BA',&nbsp; New_NET)) &lt; '30000', 'C', 0)))</P><P></P><P>I've come to the conclusion that it is the dual condition in line 2 and 3 there are causing the problem (Its a normal "and" sentence like in Excell). does anybody know how to get around this without editing the script ?</P></BODY></HTML> Fri, 03 Aug 2012 08:58:32 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/336746#M124159 2012-08-03T08:58:32Z Re: Calculated dimension https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/336747#M124160 <HTML><HEAD></HEAD><BODY><P>sorry when posting it becomes line 3-5</P></BODY></HTML> Fri, 03 Aug 2012 08:59:05 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/336747#M124160 2012-08-03T08:59:05Z