Expression Help

[#1]

Hi All,

I need an expression for  Max of dateid for system = 'XYZ'...

MAX({<System = {"XYZ"}>}(date( Date ID])))..it is not displaying the date .Can anyone help ?

[m_woolf]

What is it displaying?

[#3]

it is not displaying anything...showing empty

[m_woolf]

Can you post a sample qvw?

[m_woolf]

You have a right bracket ] with no matching left bracket.

[MK_QSL]

MAX({<System = {'X','Y','Z'}>}[Date ID]) or

MAX({<System = {'XYZ'}>}[Date ID])

[#7]

Got the answer....MAX({<System = {'XYZ'}>}[Date ID]) ..also i need to asdd the period some thing like this format ..

01/01/2013,PeriodP1 ....I have the period field...

How can we assign period ?

[juleshartley]

Do you mean that you want to filter the results to show where PeriodP1 = '01/01/2013'?

[juleshartley]

If so, you need to use syntax similar to :

MAX(

{

<System={'XYZ'},

PeriodP1={$(vDate)}

}

[Date ID]

)

where vDate is set to the filter date. But be careful - dates are trickly to get right!

[MK_QSL]

What is the comparison criteria for PeriodP1?