I have an App within Qliksense Saas which has access to the Sales by [Retailer Name] which represents individual stores. Each store is a member of a particular Format (e.g. Large Rural, Small Urban etc.).
I can create a table to show the Sum(Sales) by [Retailer Name] and add a column to rank those Sales numbers with Rank(Sum(Sales). Obviously, when I filter by Format then the rank changes for that particular Format.
What I would like to do is have a KPI visualisation called Rank Within Format so that if a particular [Retailer Name] is filtered, then it shows the number reflecting that Store's rank within its own Format.
Is there an expression within the KPI that can achieve this? All of our efforts so far returns a 1 for every store or a hyphen.
