please help me....in this query

[suvechha_b]

How can I write this in expression of qlikview??

select max(fiscal_key) from qlk_dim_period where [Fiscal Month]='Aug' and [Fiscal Year]=2012

[#2]

Hi,

Try this:

Max({$<[Fiscal Month] = {'Aug'}, [Fiscal Year] = {2012}>} fiscal_key)

You can replace the dollar-sign $ above to 1, if you want to ignore any selections made.

If fiscal_key is a string, use MaxString instead of Max.

Hope this helps.