topic Expression - returning the desired field in QlikView https://community.qlik.com/t5/QlikView/Expression-returning-the-desired-field/m-p/419811#M486980 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The below expression returns an Audit Update ID record. </P><P></P><P>aggr(num(max([Audit Update ID],2)),[Update ID],[Action Item ID])</P><P></P><P>I would like to use the above expression to get the correct Audit Update ID (which it does), and then use this to return another field value (% complete).</P><P>Any help in how I structure this would be greatly appreciated.</P><P></P><P>Thanks,</P><P>Alan</P></BODY></HTML> Thu, 07 Mar 2013 18:17:31 GMT 2013-03-07T18:17:31Z Expression - returning the desired field https://community.qlik.com/t5/QlikView/Expression-returning-the-desired-field/m-p/419811#M486980 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The below expression returns an Audit Update ID record. </P><P></P><P>aggr(num(max([Audit Update ID],2)),[Update ID],[Action Item ID])</P><P></P><P>I would like to use the above expression to get the correct Audit Update ID (which it does), and then use this to return another field value (% complete).</P><P>Any help in how I structure this would be greatly appreciated.</P><P></P><P>Thanks,</P><P>Alan</P></BODY></HTML> Thu, 07 Mar 2013 18:17:31 GMT https://community.qlik.com/t5/QlikView/Expression-returning-the-desired-field/m-p/419811#M486980 2013-03-07T18:17:31Z