topic Re: Handling an Expression as a Dimension in QlikView https://community.qlik.com/t5/QlikView/Handling-an-Expression-as-a-Dimension/m-p/443563#M165360 <HTML><HEAD></HEAD><BODY><P>try aggr(maxstring(purchasedate),product)</P><P></P><P>Note, I think you should make sure your dates are real dates and not strings so you can calculate with them. For example max(purchasedate) instead of maxstring(purchasedate). And calculations on numbers perform better than calculations on strings.</P></BODY></HTML> Thu, 09 May 2013 18:14:49 GMT Gysbert_Wassenaar 2013-05-09T18:14:49Z Handling an Expression as a Dimension https://community.qlik.com/t5/QlikView/Handling-an-Expression-as-a-Dimension/m-p/443562#M165359 <HTML><HEAD></HEAD><BODY><P>Hey guys , </P><P></P><P>I am trying to turn an expression into a dimension .</P><P></P><P>Details : i am calculating the last purchase date of a product by using the MaxString function , every product has multiple purchase dates and this shows its last . </P><P></P><P>what im trying to do is to filter and select the last purchase date in order to check which product dates to which year . but i cannot introduce the maxstring function as a calculated dimension . </P><P></P><P>any ideas about how to make this possible?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 09 May 2013 13:54:35 GMT https://community.qlik.com/t5/QlikView/Handling-an-Expression-as-a-Dimension/m-p/443562#M165359 2013-05-09T13:54:35Z Re: Handling an Expression as a Dimension https://community.qlik.com/t5/QlikView/Handling-an-Expression-as-a-Dimension/m-p/443563#M165360 <HTML><HEAD></HEAD><BODY><P>try aggr(maxstring(purchasedate),product)</P><P></P><P>Note, I think you should make sure your dates are real dates and not strings so you can calculate with them. For example max(purchasedate) instead of maxstring(purchasedate). And calculations on numbers perform better than calculations on strings.</P></BODY></HTML> Thu, 09 May 2013 18:14:49 GMT https://community.qlik.com/t5/QlikView/Handling-an-Expression-as-a-Dimension/m-p/443563#M165360 Gysbert_Wassenaar 2013-05-09T18:14:49Z