Ranking in KPI table not working

Wed, 01 Jul 2015 19:19:01 GMT

I have a rank function that works great in a straight table. I want to use the same thing in a simple kpi table and I cant figure out how to get it to work. Can anyone tell me what I'm missing?

I have 2 trim variables to take off outliers, vLTrim = .05, vUTrim = .95

I have 1 set analysis variable, vComparison_Set_Analysis = '{$ <[group]=>}'

rank(TOTAL

SUM($(vComparison_Set_Analysis)

if([revenue] >= aggr(NODISTINCT fractile( $(vComparison_Set_Analysis) [revenue], vLTrim),[fy_end]) and

[revenue] <= aggr(NODISTINCT fractile($(vComparison_Set_Analysis) [revenue] , vUTrim),[fy_end]),

[revenue])

),0,2)

topic Ranking in KPI table not working in QlikView

Ranking in KPI table not working