I am very new to Qlik and need to know how I am able to filter on previous aggregated data.
I'm a simplified way, my columns consist of something like this: (in reality I have many more dimensions)
Country
Device
Unique users
FRANCE
NULL
50000
FRANCE
IPHONE
24000
FRANCE
ANDROID
26000
I want the dashboard filter to be built so that when a user selects Country = FRANCE that it should only return 50,000 unique users and not a sum of all rows containing FRANCE. (For those familiar with SQL this was achieved via GROUPING SETS).
How is this best achieved in Qlik? Alternatively, is it better to not work with Pre calculated data and do the aggregations within Qlik itself? If so, how?
