topic Re: Rank function for KPI in QlikView

Rank function for KPI

alexandra23 — Mon, 17 Jun 2019 02:36:28 GMT

Hello,

I need to get the rank for a run-time selection and to display it to a KPI. I tried:

only({$<Dimensions={"=GetFieldSelections(Country)"} >}Aggr(Rank(Sum([Digital Economy and Society Index])), Country))

but unfortunately is not working.

Any thoughts?

Thank you!

sunny_talwar — Mon, 17 Jun 2019 13:01:46 GMT

Not sure, but are you looking for this may be

Only(Aggr(Rank(Sum({<Country>} [Digital Economy and Society Index])), Country))

alexandra23 — Mon, 17 Jun 2019 16:38:52 GMT

Thank you very much !