topic Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/317888#M1180491 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a MaxString expression with set analysis as an expression. I was wondering what I would have to do to make this a calculated demension. Here generally what the expression looks like.</P><P></P><P></P><P>MaxString({$&lt;SalesYear={"2013"}&gt;} SalesOpStatus)</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Thanks!</P><P>Jeff</P></BODY></HTML> Mon, 30 Jan 2012 18:19:00 GMT 2012-01-30T18:19:00Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/317888#M1180491 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a MaxString expression with set analysis as an expression. I was wondering what I would have to do to make this a calculated demension. Here generally what the expression looks like.</P><P></P><P></P><P>MaxString({$&lt;SalesYear={"2013"}&gt;} SalesOpStatus)</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Thanks!</P><P>Jeff</P></BODY></HTML> Mon, 30 Jan 2012 18:19:00 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/317888#M1180491 2012-01-30T18:19:00Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/317889#M1180492 <HTML><HEAD></HEAD><BODY><P>You probably want the MaxString grouped by one or more dimensions? Then you need advanced aggregation:</P><P></P><P>=aggr( MaxString({$&lt;SalesYear={"2013"}&gt;} SalesOpStatus), DIMENSION)</P></BODY></HTML> Mon, 30 Jan 2012 18:24:40 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/317889#M1180492 swuehl 2012-01-30T18:24:40Z