Ranking

[rkpatelqlikview]

Dear Qlik,

Please find the attached Qvw. I have given the rank based on the total points over the Groups (there are 5 groups.). If "Total Points are same the rank is also same for all. At this Tie Rank happened i need to check with "Total Kms travelled". Which is travelled highest kms that should be a top rank.

Below screen shot Ranks are same upto 7 CarrierNames.At this time need to check with the Kms Travelled.  Here top 1 rank must be highest kms travelled,which is 6288 is the 1, 1720 -2, Etc..

And when i select any carrier name that rank only should display instead of showing "1"

Please let me know if you want more clarity. Thanks

[mayankraoka · Accepted solution]

Hi Kumar,

Please find attached qvw.This is what you want?

Regards,

Mayank !

[rkpatelqlikview]

Hi Mayank,

Thanks for your excellent support. Exactly its correct one and when i select the CarrierName from list box the same Rank should show instead of showing the " 1" and how to display the same rank in Text object"

Thanks for your support

[mayankraoka]

It is dynamic and showing as per selection for that you need to ignore carrier name in that expression if you want to retain same Rank.

Regards,

Mayank

[rkpatelqlikview]

Thanks Mayank, Can i show the rank in Text object?

[rkpatelqlikview]

Its showing "null" values. For these values also can i get Rank based on their "Total Points"

[mayankraoka]

Yes ,you can.

[rkpatelqlikview]

The same  Expression i put in text object, and i selected the carriername, its showing only "1"

=

Aggr(

rank(

(Round(sum({<[Safety Category]={'Green'}>} [Kms Travelled]) / sum([Kms Travelled]) *100)/4)

+(Round((COUNT(DISTINCT [DEVICE NO]) -COUNT([Device Number]))/COUNT(DISTINCT  [DEVICE NO]) *100 )/4 ) +

(Round(SUM({<controlled={'Yes'}>}Quantity)/SUM({<controlled={'Yes'}+{'No'}>}Quantity)*100)/4)

+

(Round(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({< [iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100)/4)+sum([Kms Travelled])/(1E10)

,4,1),Group, [Carrier Name])