select the max value by date

[#1]

Hi,

Need some helps here.

I'm trying to show the max "Rows" value by date.

For example:

The max row for abc.qvw is on 19-09, it should show 23.

then for xyz.qvw, the max row is on 18-09, so it should show 55.

[kaushiknsolanki]

Hi,

    Ok you tell us what output you want, with example.

Regards,

Kaushik Solanki

[#3]

ok, In the final result, we should have the following...

[kaushiknsolanki]

Hi,

    Have a look at this example.

    Here if you see the data, the QVW has 19 as the max date.

Regards,

Kaushik Solanki   

[#5]

yes, but the data is wrong. The 55 should be on 18-09. not 19-09.

[kaushiknsolanki]

Hi,

    You are right,

    But for xyz.qvw your max date is 19th and the max Rows is 55. (This max rows are irrespective of date)

    If you want Max Rows for only Max Day.. Meaning For example consider you have data like this.

    QVW          Date          Rows

    ABC          19                25

    ABC          20                20

    XYZ           19                35

    XYZ           20                40

    SO when you say you want max date and max rows. the output will be

   ABC         20          25

   XYZ          20          40

     But when you say you want max rows for max day. then output will be

   ABC      20      20

    XYZ      20      40

     So now tell me what scenario from this you are looking for.

Regards,

Kaushik Solanki

[SunilChauhan]

see the attched file

chart

Max by date shows you max by date

hope this help you

[#8 · Accepted solution]

Hi

Please check my attached file.

do let me know if this one help you.

[#9]

Hi there,

Thanks for the correct answer.

What does the negative sign means infront of column name Rows?

[#10]

Nicksatch,

The Help for FirstSortedValue says:

"...By preceding the sort-value expression with a minus sign, the function will return the last value instead."