topic please help me....in this query in QlikView https://community.qlik.com/t5/QlikView/please-help-me-in-this-query/m-p/544463#M1145914 <HTML><HEAD></HEAD><BODY><P>How can I write this in expression of qlikview??</P><P></P><P>select max(fiscal_key) from qlk_dim_period where [Fiscal Month]='Aug' and [Fiscal Year]=2012</P></BODY></HTML> Wed, 31 Jul 2013 12:21:45 GMT suvechha_b 2013-07-31T12:21:45Z please help me....in this query https://community.qlik.com/t5/QlikView/please-help-me-in-this-query/m-p/544463#M1145914 <HTML><HEAD></HEAD><BODY><P>How can I write this in expression of qlikview??</P><P></P><P>select max(fiscal_key) from qlk_dim_period where [Fiscal Month]='Aug' and [Fiscal Year]=2012</P></BODY></HTML> Wed, 31 Jul 2013 12:21:45 GMT https://community.qlik.com/t5/QlikView/please-help-me-in-this-query/m-p/544463#M1145914 suvechha_b 2013-07-31T12:21:45Z Re: please help me....in this query https://community.qlik.com/t5/QlikView/please-help-me-in-this-query/m-p/544464#M1145915 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this:</P><P></P><P>Max({$&lt;[Fiscal Month] = {'Aug'}, [Fiscal Year] = {2012}&gt;} fiscal_key)</P><P></P><P>You can replace the dollar-sign $ above to 1, if you want to ignore any selections made.</P><P>If fiscal_key is a string, use MaxString instead of Max.</P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 31 Jul 2013 12:36:38 GMT https://community.qlik.com/t5/QlikView/please-help-me-in-this-query/m-p/544464#M1145915 2013-07-31T12:36:38Z