topic Re: Ranking in QlikView

Ranking

rkpatelqlikview — Mon, 23 Apr 2018 06:34:27 GMT

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

Re: Ranking

mayankraoka — Mon, 23 Apr 2018 07:01:20 GMT

Hi Kumar,

Please find attached qvw.This is what you want?

Regards,

Mayank !

Re: Ranking

rkpatelqlikview — Mon, 23 Apr 2018 07:12:37 GMT

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

Re: Ranking

mayankraoka — Mon, 23 Apr 2018 07:16:24 GMT

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

Re: Ranking

rkpatelqlikview — Mon, 23 Apr 2018 07:22:06 GMT

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

Re: Ranking

rkpatelqlikview — Mon, 23 Apr 2018 07:31:13 GMT

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

Re: Ranking

mayankraoka — Mon, 23 Apr 2018 07:31:18 GMT

Yes ,you can.

Re: Ranking

rkpatelqlikview — Mon, 23 Apr 2018 07:34:46 GMT

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])