displaying maximum value and date in text box

[#1]

Hi community,

I had a case where i need to display date and maximun of count of some value for that date  in a text box like as below

date - value.

I acheived this through script

But my problem here is the value should change according to selection monthly or weekly which is not happening. How can i do this using expressions directly?

[PrashantSangle]

Hi,

Just Nullify the other field which affect your max data.

Use this in set analysis.

Regards,

[tresesco]

Max(Date) - for max date

FirstSortedValue( field, - Date) - value of a field against max date

[#4]

Sorry, but i didn't get you. can you please explain me in detail. If possible with some example

[#5]

But i need to do some grouping right, wrt date so that i can ge the max(value)

[tresesco]

Share your sample data/qvw and state expected output.

[#7]

jus assume a case where i had date and viewers for that partcular date like below

date   viewers

21          150

14         100

06          200

21          250

14          250

06          325

.

Now i want to get the (sum(viewers)) grouped by date

date  sumof viewers

21     400

14     350

06      525.

Then from the above i need to display ina text box, maximum viewers and its corresponding date, minimum values and its corresponding date in a text box like below

max date 06-525

mindate -14-350

[#8]

Find the PFA,may you get the idea to solve your requirement..

[tresesco · Accepted solution]

='Maximum Viewers:' &MAx(Aggr(Sum(Viewers), Date))

='Maximum Viewers - Date:' &FirstSortedValue(Aggr(Date,Date),-Aggr(Sum(Viewers), Date))