{"id":43430,"date":"2018-12-01T12:28:33","date_gmt":"2018-12-01T06:58:33","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=43430"},"modified":"2018-12-01T13:47:56","modified_gmt":"2018-12-01T08:17:56","slug":"qlik-sense-aggregation-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-aggregation-functions\/","title":{"rendered":"Aggregation Functions in Qlik Sense – Types of Functions"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last Qlik Sense tutorial<\/a><\/strong>, we discussed Qlik Sense Geospatial Functions<\/strong><\/a>. The aggregation function takes in multiple values and returns an aggregated value as a result. There are two categories of aggregation functions based on its use. We use Qlik Sense Aggregation Functions in data load script and in chart expressions.\u00a0<\/span><\/p>\n

\"Aggregation<\/a>

Aggregation Functions in Qlik Sense – Types of Functions<\/p><\/div>\n

So, let’s start Qlik Sense Aggregation Functions Tutorial.<\/p>\n

2. Qlik Sense\u00a0Aggr() Chart Function<\/span><\/h2>\n

The aggr() function is a chart function which performs advanced aggregation i.e. aggregation within a function. It returns an array of values as a result of aggregation.<\/span><\/p>\n

You must read about Qlik Sense Line Chart<\/a><\/strong><\/p>\n

Syntax:<\/strong><\/p>\n

Aggr({SetExpression}[DISTINCT][NODISTINCT]expr,StructuredParameter{, StructuredParameter})<\/pre>\n
Where, <\/span>expr<\/span> is the expression having the aggr() function.<\/span><\/p>\n
The <\/span>StructuredParameter<\/span> is the name of the dimension or measure from which the values will be taken and sorted. We mention it in the expression as, (Dimension(Sort-type, Ordering)).<\/span><\/p>\n
The <\/span>SetExpression<\/span> parameter sets the set of records upon which the aggregation should be applied. If you do not mention any such set expression value, then the function applies aggregation on the set of possible records as per the selections made.<\/span><\/p>\n
DISTINCT<\/span> will return one result for each value upon which aggregation is applied.<\/span><\/p>\n
NODISTINCT<\/span> will return an array of values as a result for each value upon which aggregation is applied. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
ProductData:\r\nLOAD * inline [\r\nCustomer|Product|UnitSales|UnitPrice\r\nArman|AA|4|16\r\nArman|AA|10|15\r\nArman|BB|9|9\r\nHimesh|BB|5|10\r\nHimesh|CC|2|20\r\nHimesh|DD|25|25\r\nParth|AA|8|15\r\nParth|CC||19\r\n] (delimiter is '|');<\/pre>\n
The expression, <\/span>Avg(Aggr(Sum(UnitSales*UnitPrice), Customer))<\/span> will return three values each as the sum of sales for each customer (Arman, Himesh, Parth) i.e. 295, 715, and 120 after applying the Aggr() function on the individual values. Upon this result of three values, Avg() function is applied which returns the average of the three values, 376.6667.<\/span><\/p>\n
3. Types of Qlik Sense Aggregation Functions<\/span><\/h2>\n
\"Types<\/a>
Types of Qlik Sense Aggregation Functions<\/p><\/div>\n
Have a look at Qlik Sense Formatting Functions<\/a><\/strong><\/p>\n
a. Basic Qlik Sense Aggregation Functions<\/span><\/h3>\n
The basic aggregation functions are the most commonly used aggregation functions.<\/span><\/p>\n