I would like to ask a question regarding Top X values calculated in Geo Analytics.
Lets look at the scenario:
I would like to see on the map my top 50 best performing stores in Australia.
- As a dimension i have a store name - i want users to be able to select user friendly point (name) from the map and i want my current selection to reflect store name
- for each store i have a latitude and longitude available (so i can use them as a location attribute)
- !!! 2 stores can have exactly the same latitude and longitude (as they can be located in the building) so the coordinates can't be used as dimension
- each store has a measure against it, lets just say it is sum(SalesAmount)
SHOW 50 STORES WITH BIGGEST sum(SalesAmount) VALUE
Ideally i would like to use LIMITATIONS on DIMENSION (like on second screenshot marked in yellow) to show my Top 50 best performing stores. The issue is that the LIMITATIONS refer to first measure which is actually LOCATION, so my Top 50 gets calculated based on latitude and longitude values which is wrong.
This makes the LIMITATIONS functionality useless.
Concept of mixing "location" with measure seems to be a very annoying feature at this stage.
So the questions i have are:
- What would be the best way to achieve top 50 stores on bubble layer in this case?
- keep in mind that I cannot just put latitude and longitude to dimension (as in one location like for example shopping centre i can have more than one store and my results would be than wrong) and users want to have store names shown in selection when they click on bubble
- data set can be huge, so running calculated dimensions or complicated measures is something i can look at at the very end as a temporary workaround
- Do i really have to create complex calculated dimension (with Rank, Aggr etc to achieve this) or Set Analysis on a measure?
patricn Patric - would you be able to comment if there is a better way of doing this (TOP X)?
btw - little bit of the topic, but i think it is a voice of all Qlik GeoAnalytics users:
The another very annoying thing is lack of the basic functionality on GeoAnalytics layers which is "include zero values" checkbox. We have to create conditional statements on location field to hide locations for which measure is = 0. Below functionality exists on built in Qlik objects as GeoAnalytics is part of Qlik now i would expect this to be added ASAP.