Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank Set Analysis Expression

Hi All

I have the following expression in a straight table

=if(PhaseValue = 0 ,0,max(aggr(sum({$<DefencePhaseSort = {$(#vPHASENO2)}>} DefenceTacklesMissed),PhaseValue,PhaseDim)))

When trying to rank the data, i get the rank to equal 1 across all parameters

PhaseDim is a dimension containing 13 separate parameters looking at Tackles Missed in each parameter

The expression is looking at the max value from each PhaseDim


I want to rank the top 4 parameters in a heat map


For Example


From the attached image

I need to be able to rank the data


Rank 1 = 'Quick Ball'

Rank 2 = '2'

Rank 3 = 'Opposition Lineout'

Rank 4 = 'Opposition Kick Return'

0 Replies