topic Re: To display the highest number and Name in QlikView

To display the highest number and Name

rkpatelqlikview — Thu, 05 Apr 2018 05:11:48 GMT

Hi,

Please let me know the set expression for below scenario.

I want to show the top Driver name who has driven highest Green kms travelled.

One text object should show Driver Name another Green Kms travelled. Expression for Green km Travelled - =sum({<DriverClassification={'SGreen'}>}[Kms Travelled]). Given in Straight table.

from Below straight table. I need show the name Rakesh Kumar (highest kms travelled) and in one more text object we need show kms travelled that value 43078.

thanks in advance

Re: To display the highest number and Name

petter — Thu, 05 Apr 2018 06:08:40 GMT

This expression in a text box should give you RAKESH KUMAR:

=Only( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Driver Name] )

This expression in another text box should give you 43078:

=Sum( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Kms Travelled] )

Re: To display the highest number and Name

rkpatelqlikview — Thu, 05 Apr 2018 06:21:53 GMT

Thanks for your response Petter,

Expression ok but its not giving the output.

Here my intention is need show all the drvier names like below.. Please suggest another expression.

Re: To display the highest number and Name

rkpatelqlikview — Thu, 05 Apr 2018 06:36:16 GMT

Thanks Petter, its working now properly.