How to show Top1 value in Text box ?

[tulasiram_bitra]

Hi Frnz,

I would like to show Top 1 sum(count) based on Sum(Downtime) aggregate of code.

Please find the attached Qvw. Please help me to find this.

[swuehl · Accepted solution]

Maybe like

=Only ( aggr(If( Rank ( Sum ( Downtime ))=1, Sum(COUNT)) ,code) )

[sunny_talwar]

Try this:

=FirstSortedValue(Aggr(Sum(COUNT), code), -Aggr(Sum(Downtime), code))

[tulasiram_bitra]

Hi ,

Thanks to All.. Both Expressions Working ..Thank you ..