Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Ranking in KPI table not working

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)

Community Browser