Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Set Analysis Syntax


Can anyone explain me this expression:

Sum(TOTAL<Customer, ModelType,>{$<Event=,SubEvent=, SubEventChild==>}Days)

I am confused the syntax in RED. I understand that Event, SubEvent and SubEventChild filters are excluded here. Not sure the role of Customer and ModelType in this expression.

Please explain. 


Labels (1)
1 Reply
Specialist II
Specialist II

Using the TOTAL qualifier and set analysis inside your aggregation overrides the selection and disre... 


That means if you have a table with dimensions of Customer and ModelType, it will calculate the Sum while ignoring them.  I know that the phrase "{$<Event=,SubEvent=, SubEventChild==>}" means to ignore the users selections, but I'm not sure if it also disregards the dimensions used in a table.