Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
crichter14
New Contributor III

Rank Functions and KPI Displays

Good morning,

I've gone through several posts and tried options from:

https://community.qlik.com/t5/QlikView-Scripting/Rank-in-Textbox-as-KPI/m-p/823640
https://community.qlik.com/t5/QlikView-Scripting/Adding-rank-based-on-1-dimension-in-the-script/m-p/...

https://community.qlik.com/t5/New-to-Qlik-Sense/KPI-objects-returning-a-rank-for-a-specific-dimensio...

This last link was Sunny's and it is amazing!  But I must be missing something because I couldn't make it work in my situation.  He uses:  Only({$<Destination={"Australia"}>}Aggr(Rank(Sum(Selection)), Destination)), I would need this to aggregate and rank by Product_Style_Code and Season - we're using filters and not specifying either of these fields in the expression.

I've attached a screenshot of the table the data lives in.  The user would like the data from the Filtered Rank column expressed in a KPI.  The column is an expression:  RANK(TOTAL -AVG({$}RATE_THIS_DRESS))

Is there a correct way to use that expression in a KPI?

Right now we're hard coding the KPI box, but I'd like to move away from that.

 

Thank you in advance for any ideas or suggestions you may have,

Cheryl

 

 

 

Labels (4)