FirstSortedValue Function Problem

[manpri7078]

Hi all,

In my QVW there is a table with two columns namely Ground and Capacity. I want to display the name of the ground with the maximum capacity in a text object using firstsortedvalue function. I am using the below mentioned function :

=Firstsortedvalue(Ground,Capacity).

I want to know what is wrong in this Expression. As per my view, it should work properly.

Please guide me.

Regards,

MANISH PRASAD

[#2]

Please try :

=Firstsortedvalue(Ground,-Capacity)

Thanks

[MK_QSL]

will give you Ground for Min Capacity...

=Firstsortedvalue(Ground,Capacity).

For Max Capacity... use -Capacity

=Firstsortedvalue(Ground,-Capacity).

[MK_QSL]

Another options...

=Aggr(IF(Capacity = Max(TOTAL Capacity), Ground),Ground)

[er_mohit]

Try this

Firstsortedvalue(Ground,-Capacity)

if your capacity field haave some aggregation on particular field then try this

Firstsortedvalue(Ground,-aggr(Capacity,aggrfieldname)

here in both - sign indicate to max ground name on basis of capacity

[its_anandrjs]

There is no error in the script of firstsorted

Eg:-

=Firstsortedvalue(Ground,Capacity) >> will give you min value

=Firstsortedvalue(Ground,-Capacity) >>will give you max value

You can also use minstring and maxstring

=MinString(Capacity) for minimum

=MaxString(Capacity) for maximum

[#7]

YOU CAN USE

FIRST SORTED VALUE(GROUND,-CAPACITY)