topic Re: How to solve the Rank for same % in QlikView

How to solve the Rank for same %

rkpatelqlikview — Mon, 05 Mar 2018 06:57:53 GMT

Hi,

Please help on this.

I am struggling here to solve this ranking. If i get a same rank it should compare with another field(filed name is [Vehicle Number] based on the count vehicles. How can i include this one in my expression to resolve the same rank?

This is the expression for Rank i have given in the Straight table:

=aggr(rank(rangesum((Ceil(SUM({<[Control_Fleet (Y/N)]={'Yes'}>}Quantity)/SUM({<[Control_Fleet (Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.01,0) /4)

(Ceil(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({<[iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.1,0)/4 )

(ceil(sum({<[Safe KM driven Classification]={'Green'}>} [Kms Travelled])/sum([Kms Travelled]) *100,0.1,0) /4 )

(round((Count(DISTINCT [Vehicle Number]) - Count(DISTINCT {<Status1 = {"$(='>=' & Date(Today() - 7))"}>} [Vehicle Number]))/Count (DISTINCT [Vehicle Number]) *100, 0.01,0)/4)), 1,1), [Carrier Name])

Thanks

KUMAR.

Re: How to solve the Rank for same %

sunny_talwar — Mon, 05 Mar 2018 13:06:48 GMT

Would you be able to share a sample to check this out?

Re: How to solve the Rank for same %

rkpatelqlikview — Tue, 06 Mar 2018 07:10:46 GMT

Thanks for your reply Sunny,

Sure.

Please find the attached data. When user enter the Carrier name it should show the Rank of among their group (No.of vehicles).

If suppose the group1 no of fleets are 172 then that particular Carrier rank should be compare with that group1.

Rank of transporter current Rank 8/172 and Previous Rank 7/172..

Please let me know if you want any other data.

Please help on this.

Thanks again.

Re: How to solve the Rank for same %

rkpatelqlikview — Tue, 06 Mar 2018 07:15:06 GMT

I need to show this rank in Text Object