topic Variable with Max Value in QlikView https://community.qlik.com/t5/QlikView/Variable-with-Max-Value/m-p/247606#M94314 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try</P><P>=Max({1} SalesOrderNum)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 02 Feb 2012 11:36:22 GMT jagan 2012-02-02T11:36:22Z Variable with Max Value https://community.qlik.com/t5/QlikView/Variable-with-Max-Value/m-p/247605#M94313 <HTML><HEAD></HEAD><BODY><P>I want to create a variable with most recent sales order num</P><P>how do i do it?</P><P></P><P>i tried : max(sales Order num) but its not working</P></BODY></HTML> Thu, 02 Feb 2012 11:32:22 GMT https://community.qlik.com/t5/QlikView/Variable-with-Max-Value/m-p/247605#M94313 2012-02-02T11:32:22Z Variable with Max Value https://community.qlik.com/t5/QlikView/Variable-with-Max-Value/m-p/247606#M94314 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try</P><P>=Max({1} SalesOrderNum)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 02 Feb 2012 11:36:22 GMT https://community.qlik.com/t5/QlikView/Variable-with-Max-Value/m-p/247606#M94314 jagan 2012-02-02T11:36:22Z