Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sgqliker
Contributor II
Contributor II

Rank in a KPI chart

Hi,

Is it possible to show a tied rank in a KPI chart?

Below is the same measure but one is in a table and one is in a KPI. I can't get the KPI to display the 8-14.

I have already tried to change the format in the script e.g. rank(xxx ,0,0) but I only get either 8 or 14 - depending on the formatting).

Thanks

Rank - Qlik sense.png

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

Can you try this

MinString({$<Response_% = p([Company name])>} Aggr(
  Rank(Sum({<Response_%, QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'}>} [Weighting_factor_%]))
, [Response_%]))

 

View solution in original post

6 Replies
sunny_talwar

What is the expression used in the chart and in the kpi object?

sgqliker
Contributor II
Contributor II
Author

My expression is:


Only({$<Response_% = {"$(=GetFieldSelections([Company name]))"}>}

aggr({<Response_%>}rank(

SUM({<Response_%>}{<QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'} >} [Weighting_factor_%])
/
SUM(TOTAL {<Response_%>} {<QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'} >}Weighting_factor_%) ), [Response_%]))

 

Thanks

sunny_talwar

Can you try this

MinString({$<Response_% = p([Company name])>} Aggr(
  Rank(Sum({<Response_%, QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'}>} [Weighting_factor_%]))
, [Response_%]))

 

View solution in original post

sgqliker
Contributor II
Contributor II
Author

Thanks!

I still just get the lowest value in the KPI chart, but the range in the table:

Rank - Qlik sense.png

 

sunny_talwar

Change Number Formatting to Measure expression

image.png

sgqliker
Contributor II
Contributor II
Author

Fab! thanks very much