Rank Functions and KPI Displays

crichter14 — Sat, 16 Nov 2024 05:36:24 GMT

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/1421976

https://community.qlik.com/t5/New-to-Qlik-Sense/KPI-objects-returning-a-rank-for-a-specific-dimension-value/td-p/1350322

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

topic Rank Functions and KPI Displays in App Development

Rank Functions and KPI Displays