topic Re: Rank Issues in Double Conditions in QlikView

Rank Issues in Double Conditions

Mon, 23 Jun 2014 08:40:04 GMT

Hi Guys,

The same ranks in the first column, I need to rank according to the reference_rank.

alexandros17 — Mon, 23 Jun 2014 08:56:46 GMT

Are you sure you need rank for the second condition? Isn't it Enough sort?

Mon, 23 Jun 2014 09:01:50 GMT

The first column has the same rank, like 4, 7,12. I need to distiguish the rank by the third field, like Rank_1

alexandros17 — Mon, 23 Jun 2014 09:09:13 GMT

what about concatenate the two fields into one and then ranking this new one?

Mon, 23 Jun 2014 09:13:26 GMT

only the duplicated rank need to rank again..

Wed, 17 Sep 2014 03:00:30 GMT

rank(total (

-rank(Totoal_Pts,1,1)*NoOfRows()+rank(Reference_Rank,1,1)

))

It's can also adapt to any number of conditions.