Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please try :
=Firstsortedvalue(Ground,-Capacity)
Thanks
will give you Ground for Min Capacity...
=Firstsortedvalue(Ground,Capacity).
For Max Capacity... use -Capacity
=Firstsortedvalue(Ground,-Capacity).
Another options...
=Aggr(IF(Capacity = Max(TOTAL Capacity), Ground),Ground)
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
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
YOU CAN USE
FIRST SORTED VALUE(GROUND,-CAPACITY)