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.

[#2]

Hi,

Use Maxstring function in place of sum

HTH

Reg,

Shubhu

[#3]

In fact, i have tried so many possible ways.

None works....

so i suspect, it's either not possible to do it with that structure, or we need to manipulate the data further.

this expression works if only there's only one date row. when u have multiples, it wont work.

MaxString(if(DATE=aggr(maxstring(DATE),QVW),ROWS))

[kaushiknsolanki]

Hi,

    Have a look at the attachment.

Regards,

Kaushik Solanki  

[Sokkorn]

Hi,

Try to change from sum(Rows) to max(Rows).

Regards,

Sokkorn

[#6]

Hi,

Check the attached doc.

Reg,

Shubhu

[#7]

Hi Kaushik,

Thanks, but i need it in the table.

[#8]

Hi Shubhu,

Neat, but the data is wrong. the 55 is on 18-09. not 19-09.

Thanks.

[kaushiknsolanki]

Hi,

    OK have a look at the file.

Regards,

Kaushik Solanki

[#10]

Hi Kaushik,

Thanks agian, but the max() wont work if we want QVD | DATE | ROWS in the table.

Any other tips?