Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Creator II
Creator II

Rank Caluculation Using aggr() functions

Hi all,

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

 

XYYTD salesXY RankY rank
9000119
8000227
7000583
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.

4 Replies
anindya_manna
Creator II
Creator II
Author

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

sunny_talwar

Which of the two isn't working? XY or Y?

anindya_manna
Creator II
Creator II
Author

Both of them

sunny_talwar

Would you be able to share a sample where we can see the issue.... and also if you can share the output you expect to see based on the selection... then that would be great