Rank Caluculation Using aggr() functions

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

Hi all,

I am calculating rank in a table. my report looks like after selecting a dimension like below.

X	Y	YTD sales	XY Rank	Y rank
		9000	1	19
		8000	2	27
		7000	5	83
		6000
		5000

Rank calculation is done based on this below expression.

XY Rank = Aggr(Nodistinct rank(sum({$<[Process Date]={">=$(=YearStart(Max([Process Date]))) <=$(=Max([Process Date]))"},

[Month ID]=>}[Sales Amt]),4),X,Y).

Y Rank=aggr(Nodistinct rank(sum({$<=,[Month ID]=,[Process Date]={">=$(=YearStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])),).

But the problem is when I am selecting other dimension like Month Id the rank calculation is not based on this particular month so by selecting a particular month rank is showing 1,2,3,6,9,12, like this as other position not part in this month so they removed.

But I want continuous rank based on each dimension selection.

Re: Rank Caluculation Using aggr() functions

anindya_manna — Fri, 19 Jan 2018 12:25:20 GMT

When I am not selecting Month Id reports looks good. But when selecting any dimension like Month id its not showing desired result.

Re: Rank Caluculation Using aggr() functions

sunny_talwar — Fri, 19 Jan 2018 13:26:00 GMT

Try not to create duplicate thread for the same issue

Rank Caluculation Using aggr() functions

topic Rank Caluculation Using aggr() functions in QlikView

Rank Caluculation Using aggr() functions

Re: Rank Caluculation Using aggr() functions

Re: Rank Caluculation Using aggr() functions