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: 
rtrochim
Contributor II
Contributor II

Aggr Rank function

Hi,

I am looking for a simple solution to combine two columns with with rank function. At the moment both columns are based on "rank" function". As a result it will be total rank based on rank values. Here is the syntax I am using at the moment and the result is "-" no values at all. Any ideas how to fix that?

=(Aggr(rank(Aggr(rank(total Sum(Metric 1),4,0)))+(Aggr(rank(total count(Metric2),4,0))),4,0))

Regards

Rafal

Labels (2)
0 Replies