topic Re: Question on FirstSortedvalue formula in QlikView

Question on FirstSortedvalue formula

danialier — Mon, 07 Jul 2014 08:49:23 GMT

Hello,

I have the attached QV document with a black text box showing the company name that has the highest revenue. When I select a month the black box returns the right company name based on the highest revenue. However when I select all months the black box returns a wrong company name.

Please help !

Thanks,

dani

Re: Question on FirstSortedvalue formula

jagan — Mon, 07 Jul 2014 09:16:22 GMT

Hi,

Try like this

=FirstSortedValue(Company, -Aggr(Sum(Revenue), Company))

Regards,

Jagan.

Re: Question on FirstSortedvalue formula

parthiband — Mon, 07 Jul 2014 09:27:00 GMT

Try this too

Only({$<Company={"=Rank(Sum(Revenue),4,1)=1"}>}Company)

Thanks,

Re: Question on FirstSortedvalue formula

danialier — Mon, 07 Jul 2014 09:53:46 GMT

Great, thanks Jagan !