Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering on Pre Calculated Data

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)

CountryDeviceUnique users
FRANCENULL50000
FRANCEIPHONE24000
FRANCEANDROID26000

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?

1 Reply
sunny_talwar

Check my response here: Filtering on Pre Calculated Data