Maximum value over a dimension

[richard_chilvers]

Apologies if this question has been answered previously!

My data is as follows:

Code	Date	Value
A	10/11/2012	10
A	11/11/2012	12
A	16/11/2012	13
B	10/11/2012	27
C	11/11/2012	6
C	13/11/2012	8
C	15/11/2012	13

I would like a chart over dimension Code, selecting just the single value for each Code with the latest (MAX) date.

ie. A=13, B=27 and C=13 (ultimately, I will be summing all these values).

Advice please

Thanks

[swuehl · Accepted solution]

Try

=FirstSortedValue(Value, -Date)

as expression (Date should be interpreted as Date with a numeric representation by QV already), using Code as dimension.

[shree909]

hi

if u think that maxvalue is  always calculated only for latest date then u can write max(only{<date=${'maxdate'}>} value)

so create a maxdate variable

[richard_chilvers]

Thank you !

I have not used that function before

[yashcena]

Hi Stefan,

I have a similar requirement

This is how my chart looks like now:

I want the chart like this:

With Week also added as a  dimension in the chart (along with resourcename), the firstsortvalue then sorts for each week. So I get the same thing:

Expression: FirstSortedValue([Remaining Hours],date#(Week))

But I get the same chart:

Is there any way to do what I'm looking for?

Thanks,

YASH

[swuehl]

Use Remaining Hours as second dimension and Min(Week) as expression.