topic Re: Error in calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388895#M145150 <HTML><HEAD></HEAD><BODY><P>Could you post a sample of your app?</P></BODY></HTML> Wed, 31 Oct 2012 13:58:51 GMT Clever_Anjos 2012-10-31T13:58:51Z Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388889#M145144 <HTML><HEAD></HEAD><BODY><P>Hi, I'm Traying to use the function Distinct for eliminate duplicate text.</P><P></P><P>like:</P><P></P><P>P</P><P>P</P><P>A</P><P>M</P><P>M</P><P>S</P><P></P><P>I need </P><P>P</P><P>A</P><P>M</P><P>S</P><P></P><P>I have =Concat(Distinct(Field))</P><P></P><P>But appear an error.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 31 Oct 2012 13:41:34 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388889#M145144 pgalvezt 2012-10-31T13:41:34Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388890#M145145 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Normally, the rows with the same value get aggregated in the chart anyway. There is no need for a calculated dimension for this purpose. Just use the field as a dimension.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 31 Oct 2012 13:46:05 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388890#M145145 jonathandienst 2012-10-31T13:46:05Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388891#M145146 <HTML><HEAD></HEAD><BODY><P>You don´t need this, if you use a field as dimention, QV will use only distinct values.</P></BODY></HTML> Wed, 31 Oct 2012 13:49:52 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388891#M145146 Clever_Anjos 2012-10-31T13:49:52Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388892#M145147 <HTML><HEAD></HEAD><BODY><P>I tried:</P><P>=Concat(Distinct Field)</P><P></P><P>Nothing Happened.</P></BODY></HTML> Wed, 31 Oct 2012 13:51:21 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388892#M145147 pgalvezt 2012-10-31T13:51:21Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388893#M145148 <HTML><HEAD></HEAD><BODY><P>I put my field as a dimension this is my result for 1 account:</P><P></P><P>Sells</P><P>Sells</P><P>Sells</P><P>Sells</P><P>Sells</P><P>So on</P></BODY></HTML> Wed, 31 Oct 2012 13:54:13 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388893#M145148 pgalvezt 2012-10-31T13:54:13Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388894#M145149 <HTML><HEAD></HEAD><BODY><P>I think with concat and distinct functions should be working.I think something missing</P></BODY></HTML> Wed, 31 Oct 2012 13:56:27 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388894#M145149 pgalvezt 2012-10-31T13:56:27Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388895#M145150 <HTML><HEAD></HEAD><BODY><P>Could you post a sample of your app?</P></BODY></HTML> Wed, 31 Oct 2012 13:58:51 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388895#M145150 Clever_Anjos 2012-10-31T13:58:51Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388896#M145151 <HTML><HEAD></HEAD><BODY><P>Thank you for your replys guys. I can't send you a sample because my model is too heavy 300MB. But I Attached a file picture That I have.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 31 Oct 2012 14:16:57 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388896#M145151 pgalvezt 2012-10-31T14:16:57Z Re: Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388897#M145152 <HTML><HEAD></HEAD><BODY><P>Please send a pic of your Dim and Expressions tabs</P></BODY></HTML> Wed, 31 Oct 2012 15:39:47 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/388897#M145152 Clever_Anjos 2012-10-31T15:39:47Z