topic Re: FirstSortedValue Function Problem in QlikView

FirstSortedValue Function Problem

manpri7078 — Thu, 17 Apr 2014 10:23:16 GMT

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

Re: FirstSortedValue Function Problem

Thu, 17 Apr 2014 10:25:07 GMT

Please try :

=Firstsortedvalue(Ground,-Capacity)

Thanks

Re: FirstSortedValue Function Problem

MK_QSL — Thu, 17 Apr 2014 10:27:07 GMT

will give you Ground for Min Capacity...

=Firstsortedvalue(Ground,Capacity).

For Max Capacity... use -Capacity

=Firstsortedvalue(Ground,-Capacity).

Re: FirstSortedValue Function Problem

MK_QSL — Thu, 17 Apr 2014 10:29:43 GMT

Another options...

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

Re: FirstSortedValue Function Problem

er_mohit — Thu, 17 Apr 2014 10:29:46 GMT

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

Re: FirstSortedValue Function Problem

its_anandrjs — Thu, 17 Apr 2014 10:53:32 GMT

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

Re: FirstSortedValue Function Problem

Thu, 17 Apr 2014 11:00:19 GMT

YOU CAN USE

FIRST SORTED VALUE(GROUND,-CAPACITY)