Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Ok you tell us what output you want, with example.
Regards,
Kaushik Solanki
ok, In the final result, we should have the following...
Hi,
Have a look at this example.
Here if you see the data, the QVW has 19 as the max date.
Regards,
Kaushik Solanki
yes, but the data is wrong. The 55 should be on 18-09. not 19-09.
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
see the attched file
chart
Max by date shows you max by date
hope this help you
Hi
Please check my attached file.
do let me know if this one help you.
Hi there,
Thanks for the correct answer.
What does the negative sign means infront of column name Rows?
Nicksatch,
The Help for FirstSortedValue says:
"...By preceding the sort-value expression with a minus sign, the function will return the last value instead."