topic aggr and firstsortedvalue expression fails when fields changed to text in QlikView https://community.qlik.com/t5/QlikView/aggr-and-firstsortedvalue-expression-fails-when-fields-changed/m-p/261460#M1189363 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a calculated dimension:</P><P>=aggr(firstsortedvalue({&lt;ContactType={'Email'}&gt;}ContactDetail,-ContactID),TR_ID)</P><P></P><P>This was working ok until the format of the ContactID and TR_ID fields changed from numeric (e.g. 95423) to text (e.g. ABC95423).</P><P></P><P>The dimension is used in a straight table chart and has changed from returning the email address field to being unable to return anything, just a - in the field.</P><P>Can anyone help?<BR />Thanks, Catherine.</P></BODY></HTML> Wed, 14 Sep 2011 13:56:31 GMT 2011-09-14T13:56:31Z aggr and firstsortedvalue expression fails when fields changed to text https://community.qlik.com/t5/QlikView/aggr-and-firstsortedvalue-expression-fails-when-fields-changed/m-p/261460#M1189363 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a calculated dimension:</P><P>=aggr(firstsortedvalue({&lt;ContactType={'Email'}&gt;}ContactDetail,-ContactID),TR_ID)</P><P></P><P>This was working ok until the format of the ContactID and TR_ID fields changed from numeric (e.g. 95423) to text (e.g. ABC95423).</P><P></P><P>The dimension is used in a straight table chart and has changed from returning the email address field to being unable to return anything, just a - in the field.</P><P>Can anyone help?<BR />Thanks, Catherine.</P></BODY></HTML> Wed, 14 Sep 2011 13:56:31 GMT https://community.qlik.com/t5/QlikView/aggr-and-firstsortedvalue-expression-fails-when-fields-changed/m-p/261460#M1189363 2011-09-14T13:56:31Z