topic Re: Ranking expression value in QlikView

Ranking expression value

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a table with a few dimensions, and several expressions.

But, a basic version of the table is:

DIM - ID	DIM - Type	EXP - Avg(Score)	RANK
123	A	15.3	1/8
123	B	16.5	2/8
123	C	28.5	6/8
456	A	17	3/8
456	B	71.2	8/8
789	A	21	5/8
234	A	19	4/8
234	B	37.5	7/8

What I would like, is another expression that ranks the expression value, and tells me how many places it's out of - so the fourth column.

How would I do this?

sunny_talwar — Thu, 02 Nov 2017 13:32:01 GMT

May be this

Rank(Avg(Score)) & '/' & Count(TOTAL ID)

jessica_webb — Thu, 02 Nov 2017 13:41:52 GMT

No, that just gives me 1/8 for every value...

sunny_talwar — Thu, 02 Nov 2017 13:44:23 GMT

My bad, try this

Rank(TOTAL Avg(Score)) & '/' & Count(TOTAL ID)

sunny_talwar — Thu, 02 Nov 2017 13:44:49 GMT

Or this

(Count(TOTAL ID) - Rank(Avg(Score)) + 1) & '/' & Count(TOTAL ID)

jessica_webb — Thu, 02 Nov 2017 13:55:10 GMT

Perfect - thank you very much