Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Check my response here: Filtering on Pre Calculated Data