{"id":38843,"date":"2018-11-10T12:12:05","date_gmt":"2018-11-10T06:42:05","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38843"},"modified":"2021-12-07T11:20:25","modified_gmt":"2021-12-07T05:50:25","slug":"qlikview-aggregate-function-aggr","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/","title":{"rendered":"QlikView Aggregate Function – 6 Types of AGGR() Function"},"content":{"rendered":"

One of the very useful functions amongst the long list of functions that we saw in the previous tutorial is QlikView Agg() Function category. In this QlikView Aggregate Function, we are going to gain a better understanding of aggregate functions and also learn to apply these functions to our data. <\/span><\/span><\/p>\n

Along with this, we will learn different types of Aggregate Function in QlikView<\/strong><\/a> with their subtypes and examples.<\/span><\/span><\/p>\n

So, Let’s start QlikViewAggregate Function.<\/span><\/span><\/p>\n

\"QlikView<\/a>

QlikView Aggregate Function – 6 Types of AGGR() Function<\/p><\/div>\n

What is QlikView Aggregate Function?<\/h3>\n

QlikView Aggregate function is provided to aggregate or bundle your data from the rows in the table. You can apply mathematical or statistical operations collectively on large data loads. There are sub-categories or types of QlikView aggregate function each based on the action they perform on the data. <\/span><\/span><\/p>\n

You can apply these functions to the table fields while loading your data files in the qlikview script editor. A <\/span><\/span>Group By<\/b><\/span><\/span> clause is very essential to add while incorporating the QlikView aggregate function in the load statement. This clause specifies the field in the table of which you want the data to aggregate.<\/span><\/span><\/p>\n

Do you know How to Create, Import, Remove QlikView Bookmarks?<\/a><\/strong><\/p>\n

Types of Aggregate Function in QlikView<\/h3>\n

There are seven different sub-categories of QlikView aggregate function. Here we will study some function sub-category with the function they perform and examples in details.<\/span><\/span><\/p>\n

i. Basic Aggregation Functions<\/h4>\n

We will use a reference data record of Product details and apply the QlikView aggregate function on it.<\/span><\/span><\/p>\n

\"QlikView<\/a>

QlikView Aggregate Function – Basic Aggregation Functions<\/p><\/div>\n

a. sum([distinct]expression)<\/h5>\n

Returns the sum of a number of records of the field defined by a <\/span>group by <\/b><\/span>clause. If the word <\/span>distinct <\/b><\/span>occurs before the expression, all duplicates will be disregarded.<\/span><\/p>\n

Example:<\/b><\/span><\/p>\n

Productrecords:\r\nLOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost\r\nFROM\r\n[C:\\Users\\admin\\Desktop\\Dataflair\\productrecord.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nTotal:\r\nLOAD\r\n    Product_Line, sum(Product_quantity) as [Totalquantity],\r\n                  sum(Product_cost) as [Totalcost]\r\n     Resident Productrecords Group by Product_Line;\r\n     Drop table Productrecords;<\/pre>\n
\"QlikView<\/a>
QlikView Aggregate Function – sum([distinct]expression)<\/p><\/div>Here, we have added product quantity and cost on the basis of the Product line. You can notice it in the output table with total quantity and total cost.<\/span><\/p>\n
Let’e Explore different types of QlikView Operators with examples<\/a><\/strong><\/p>\n
b. min( expression, rank )<\/h5>\n
Returns the minimum numeric value amongst the whole set of records as defined by a <\/span>group by <\/b><\/span>clause. Rank defaults to 1 which corresponds to the lowest value. By specifying rank as 2 the second lowest value will be returned and so on.<\/span><\/p>\n
Examples:<\/b><\/span><\/p>\n
Load Product_Line, min(Product_quantity) as minquantity from productrecords.csv group by<\/i><\/span><\/p>\n
Product_Line;<\/i><\/span><\/p>\n
Load Product_Line, min(Product_quantity, 2) as Secondminquantity from productrecords.csv<\/i><\/span><\/p>\n
group by Product_Line;<\/i><\/span><\/p>\n
c. max(expression, rank)<\/h5>\n
Returns the maximum numeric value encountered over a number of records. Rank defaults to 1 which corresponds to the highest value. By specifying rank as 2 the second highest value will be returned and so on.<\/span><\/p>\n
Examples:<\/b><\/span><\/p>\n
Load Product_Line, max(Product_quantity) as maxquantity<\/i><\/span><\/p>\n
from productrecords.csv group by<\/i><\/span><\/p>\n
Product_Line;<\/i><\/span><\/p>\n
Load Product_Line, max(Product_quantity, 2) as Secondmaxquantity <\/i><\/span><\/p>\n
from productrecords.csv<\/i><\/span><\/p>\n
Productrecords:\r\nLOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost\r\nFROM\r\n[C:\\Users\\admin\\Desktop\\Dataflair\\productrecords.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nTotal\r\nLOAD\r\n    Product_Line,\r\n    min(Product_quantity) as minquantity,\r\n    max(Product_quantity) as maxquantity\r\n    Resident Productrecords Group by Product_line;\r\n    Drop table productrecords;<\/pre>\n
\"QlikView<\/a>
QlikView Aggregate Function – max(expression, rank)<\/p><\/div>\n
d. only(expression )<\/span><\/h5>\n
If an expression contains only one numeric value, that value is returned. Else, NULL is returned.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, only(Price) as OnlyPriceSoldFor from abc.csv group by<\/span><\/p>\n
Month;<\/span><\/p>\n
Also, Read\u00a0QlikView Script Statements and Keywords<\/a><\/strong><\/p>\n
e. mode(expression )<\/span><\/h5>\n
Returns the mode value, i.e. the most commonly occurring value, of expression over a number of records. If more than one value is equally commonly occurring, NULL is returned.<\/span><\/p>\n
Mode <\/b><\/span>can return numeric values as well as text values.<\/span><\/p>\n
Examples:<\/b><\/span><\/p>\n
Load Month, mode( ErrorNumber ) as MostCommonErrorNumber from abc.csv<\/span><\/p>\n
group by Month;<\/span><\/p>\n
Load Month, mode( Product ) as ProductMostOftenSold from abc.csv group<\/span><\/p>\n
by Month;<\/span><\/p>\n
f. firstsortedvalue (expression, sort-weight, n)<\/span><\/h5>\n
Returns the first value of expression sorted by the corresponding sort-weight when an expression is iterated over a number of records. Sort-weight should return a numeric value where the lowest value will render the corresponding value of the expression to be sorted first. By preceding the sort-value expression with a minus sign, the function will return the last value instead. <\/span><\/p>\n
If more than one value of expression share the same lowest sort-order, the function will return NULL. By stating an n larger than 1, the nth value in order will be returned. If the word <\/span>distinct <\/b><\/span>occurs before the expression, all duplicates will be disregarded.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Product_Line,<\/span><\/p>\n
Firstsortedvalue (Product_category, Product_quantity) as MostBoughtProduct<\/span><\/p>\n
from Productrecords.csv group by Product_Line;<\/span><\/p>\n
Returns the value of the MostBoughtProduct-87- Power Equipment<\/span><\/p>\n
ii. String Aggregate Functions<\/h4>\n
This is the second type of QlikView Aggregate Function, let’s see its sub catagory:<\/p>\n
a. MinString(expression)<\/span><\/h5>\n
Returns the first text value from records. If no text value is found, NULL is returned.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, MinString(Month) as FirstSalesMonth from abc.csv group by<\/span><\/p>\n
Year;<\/span><\/p>\n
b. MaxString(expression )<\/h5>\n
Returns the last text value from records. If no text value is found, NULL is returned.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, MaxString(Month) as LastSalesMonth from abc.csv group by<\/span><\/p>\n
Year;<\/span><\/p>\n
c. FirstValue(expression)<\/h5>\n
Returns the first value in load order. If no text value is found, NULL is returned. This function is only available as a script function.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load City, FirstValue(Name), as FirstName from abc.csv group by City;<\/span><\/p>\n
d. LastValue(expression)<\/h5>\n
Returns the last value in load order.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load City, LastValue(Name), as FirstName from abc.csv group by City;<\/span><\/p>\n
Do you know How to Apply QlikView Layout Themes?<\/a><\/strong><\/p>\n
e. concat (expression , delimiter , sort-weight)<\/h5>\n
Returns the aggregated string concatenation of all values of expression iterated through data. Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Department, concat(Name,’;’) as NameList from abc.csv group by<\/span><\/p>\n
Department;<\/span><\/p>\n
iii. Counter Aggregation Functions<\/h4>\n
a. count([distinct ] expression | *)<\/span><\/h5>\n
Returns the count of expression over a number of records.<\/span><\/p>\n
Examples:<\/b><\/span><\/p>\n
Load Product_Line, count(Product_cost) as TotalSalesPerMonth from Productrecords.csv<\/i><\/span><\/p>\n
Group by Product_Line;<\/i><\/span><\/p>\n
Returns the total count of sales in a month.\u00a0<\/span><\/p>\n
b. NumericCount(expression)<\/h5>\n
Returns the numeric count.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, NumericCount(products) as Totalproducts from products.csv<\/i><\/span><\/p>\n
group by Month;<\/span><\/p>\n
Result will be total number of products sold in the data record.\u00a0<\/span><\/p>\n
c. TextCount(expression)<\/h5>\n
Returns the text count .<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, TextCount(Item) as NumberOfTextItems from abc.csv group by<\/span><\/p>\n
Month;\u00a0<\/span><\/p>\n
d. NullCount(expression )<\/h5>\n
Returns the NULL count of expression.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, NullCount(Item) as NumberOfNullItems from abc.csv group by<\/span><\/p>\n
Month;\u00a0<\/span><\/p>\n
e. MissingCount(expression )<\/h5>\n
Returns the missing count.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, MissingCount(Item) as NumberOfMissingItems from abc.csv<\/span><\/p>\n
group by Month;\u00a0<\/span><\/p>\n
f. Advanced Aggregation<\/h5>\n
aggr (<\/b><\/span>[ <\/i><\/span>distinct <\/b><\/i><\/span>| <\/i><\/span>nodistinct <\/b><\/i><\/span>] [set_expression]expression {dimension}<\/i><\/span>)<\/b><\/span><\/p>\n
Returns a set of values of <\/span>expression <\/i><\/span>calculated over <\/span>dimensions<\/i><\/span>. The result can be compared to the expression column of a ‘local chart’, evaluated in the context where the <\/span>aggr <\/b><\/span>function resides. Each <\/span>dimension <\/i><\/span>must be a single field. It cannot be an expression (calculated dimension). <\/span><\/p>\n
If the <\/span>expression <\/i><\/span>argument is preceded by the <\/span>nodistinct <\/b><\/span>qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure.<\/span><\/p>\n
If the <\/span>expression <\/i><\/span>argument is preceded by the <\/span>distinct <\/b><\/span>qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value.<\/span><\/p>\n
By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a <\/span>Set Analysis <\/i><\/span>expression.<\/span><\/p>\n
By using this function in <\/span>Add calculated dimension <\/i><\/span>it is possible to achieve nested chart aggregation in multiple levels.<\/span><\/p>\n
Examples:<\/b><\/span><\/p>\n
In the screenshots attached below , we have loaded sales data inline and have applied aggr function to calculate the sum of total sales done by each salesman. We have done this in a chart sheet object.<\/span><\/p>\n
LOAD * INLINE [\r\n   Customer, Sales, Product, SalesPerson\r\n   A-Mart, 50000, \"Children's wear\", John\r\n   A-mart, 25000, \"Men's wear\", Beth\r\n   A-mart, 30000, \"Women's wear\", John\r\n   Vogue, 10000, \"Men's wear\", Mike\r\n   Vogue, 15000, \"Children's wear\", Susan\r\n   Vogue, 10000, \"Men's wear\", Susan\r\n   C-Mart, 40000, \"Children's wear\", Brad\r\n   C-Mart, 90000, \"Men's wear\", Dan\r\n   C-Mart, 60000, \"Women's wear\", Brad\r\n];<\/pre>\n
\""<yoastmark\"<\/a><\/p>\n
\"QlikView<\/a>
Aggr Function – Advanced Aggregation<\/p><\/div>\n
Have a look – QlikView Simple Network Management Protocol (SNMP)<\/a><\/strong><\/p>\n
iv. Statistical Aggregation Functions<\/h4>\n
a. fractile(<\/span>expression, fractile<\/i><\/span>)<\/span><\/h5>\n
Returns the fractile of <\/span>expression <\/i><\/span>.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Class, fractile( Grade, 0.75 ) as F from abc.csv group by Class;\u00a0<\/span><\/p>\n
b. kurtosis(<\/span>expression <\/i><\/span>)<\/span><\/h5>\n
Returns the kurtosis of <\/span>expression. Kurtosis measures the peak of a frequency distribution curve.<\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, kurtosis(Sales) as SalesKurtosis from abc.csv group by<\/span><\/p>\n
Month;\u00a0<\/span><\/p>\n
c. correl(<\/span>x-expression, y-expression<\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated correlation coefficient for a series of coordinates represented by paired numbers in x-expression and y-expression iterated over a number of records . Text values, null values and missing values in any or both pieces of a data-pair will result in the entire data-pair to be disregarded.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, correl(X,Y) as CC from abc.csv group by Month;\u00a0<\/span><\/p>\n
d. avg(<\/span>expression<\/i><\/span>)<\/span><\/h5>\n
Returns the average of <\/span>expression.<\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Productrecords:\r\nLOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost\r\nFROM\r\n[C:\\Users\\admin\\Desktop\\Dataflair\\productrecord.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nTotal:\r\nLoad\r\n    Product_Line, avg(product_quantity),\r\n                  avg(product_cost)\r\n     Resident Productrecords Group by Product_Line;\r\n     Drop table productrecords;<\/pre>\n
\"QlikView<\/a>
QlikView Aggregate Function – avg(expression)<\/p><\/div>\n
e. stdev(<\/span>expression<\/i><\/span>)<\/span><\/h5>\n
Returns the standard deviation of <\/span>expression.<\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, stdev(Sales) as SalesStandardDeviation from abc.csv group<\/span><\/p>\n
by Month;\u00a0<\/span><\/p>\n
f. skew(<\/span>expression<\/i><\/span>)<\/span><\/h5>\n
Returns the skewness of <\/span>expression <\/i><\/span>.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Month, skew(Sales) as SalesSkew from abc.csv group by Month;\u00a0<\/span><\/p>\n
Do you know How to apply Trellis in Pie and Bar Charts in QlikView?<\/a><\/strong><\/p>\n
g. median (<\/span>expression<\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated median of <\/span>expression.<\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Class, Median(Grade) as MG from abc.csv group by Class;\u00a0<\/span><\/p>\n
h. linest_m (<\/span>y-expression, x-expression [, y0 [, x0 ]]<\/i><\/span>)<\/span><\/h5>\n
returns the aggregated m value (slope) of a linear regression defined by the equation y=mx+b for a series of coordinates represented by paired numbers in <\/span>x-expression <\/i><\/span>and <\/span>y-expression <\/i><\/span>defined by a <\/span>group by <\/b><\/span>clause.<\/span><\/p>\n
The function requires at least two valid data-pairs to calculate. If y<\/span>0 <\/i><\/span>and x<\/span>0 <\/i><\/span>are stated, a single data pair will do.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Key, linest_m(Y,X) as Z from abc.csv group by Key;\u00a0<\/span><\/p>\n
i. linest_b (<\/span>y-expression, x-expression [, y0 [, x0 ]]<\/i><\/span>)<\/span><\/h5>\n
returns the aggregated b value (y-intercept) of a linear regression defined by the equation y=mx+b for a series of coordinates represented by paired numbers in <\/span>x-expression <\/i><\/span>and <\/span>y-expression.<\/i><\/span><\/p>\n
An optional value y<\/span>0 <\/i><\/span>may be stated forcing the regression line to pass through the y-axis at a given point.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Key, linest_b(Y,X) as Z from abc.csv group by Key;\u00a0<\/span><\/p>\n
j. linest_r2 (<\/span>y-expression, x-expression [, y0 [, x0 ]]<\/i><\/span>)<\/span><\/h5>\n
returns the aggregated r2 value (coefficient of determination) of a linear regression defined by the equation y=mx+b for a series of coordinates represented by paired numbers in <\/span>x-expression <\/i><\/span>and <\/span>y-expression<\/i><\/span>.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Key, linest_r2(Y,X) as Z from abc.csv group by Key;\u00a0<\/span><\/p>\n
k. linest_sem (<\/span>y-expression, x-expression [, y0 [, x0 ]]<\/i><\/span>)<\/span><\/h5>\n
returns the aggregated standard error of the m value of a linear regression defined by the equation y=mx+b for a series of coordinates represented by paired numbers in <\/span>x-expression <\/i><\/span>and <\/span>y-expression <\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Key, linest_sem(Y,X) as Z from abc.csv group by Key;\u00a0<\/span><\/p>\n
i. linest_seb (<\/span>y-expression, x-expression [, y0 [, x0 ]]<\/i><\/span>)<\/span><\/h5>\n
returns the aggregated standard error of the b value of a linear regression defined by the equation y=mx+b for a series of coordinates represented by paired numbers in <\/span>x-expression <\/i><\/span>and <\/span>y-expression.<\/i><\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Key, linest_seb(Y,X) as Z from abc.csv group by Key;<\/span><\/p>\n
v. Financial Aggregate Function<\/h4>\n
This is the last QlikView Aggregate Function, let’s discuss its types:<\/p>\n
a. irr(<\/span>expression<\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated internal rate of return for a series of cash flows represent by the numbers in expression iterated over a number of records as defined by a group by clause. These cash flows do not have to be even, as they would be for an annuity. <\/span><\/p>\n
However, the cash flows must occur at regular intervals, such as\u00a0<\/span>monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods. <\/span><\/p>\n
The function needs at least one positive and one negative value to calculate. Text values, null values and missing values disregard.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Year, irr(Payments) as IRate from abc.csv<\/span><\/p>\n
group by Year;\u00a0<\/span><\/p>\n
Let’s Explore QlikView Tables – Cross, Straight, Pivot, Mapping Tables<\/a><\/strong><\/p>\n
b. xirr (<\/span>value expression, date expression <\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated internal rate of return for a schedule of cash flows (that is not necessarily periodic) represent by pair numbers in value expression and date expression iterated over a number of records as defined by a group by clause. All payments discount base on a 365-day year. Text values, null values\u00a0<\/span>and missing values in any or both pieces of a data-pair will result in the entire data-pair to be disregarded.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Year, xirr(Payments, PayDates) as Irate from abc.csv group by<\/span><\/p>\n
Year;\u00a0<\/span><\/p>\n
c. npv (<\/span>rate, expression<\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated net present value of an investment based on a discount rate and a series of future payments (negative values) and incomes (positive values) represented by the numbers in expression iterated over a number of records as defined by a group by clause. <\/span><\/p>\n
The result has a default number format of money. The rate is the interest rate per period. The payments and incomes assume to occur at the end of each period. Text values, null values and missing values disregard.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Year, npv(0.05, Payments) as PValue from abc.csv group by Year;\u00a0<\/span><\/p>\n
d. xnpv (<\/span>rate, value expression, date expression<\/i><\/span>)<\/span><\/h5>\n
Returns the aggregated net present value for a schedule of cash flows (not necessarily periodic) represented by paired numbers in value expression and date expression iterated over a number of records as defined by a\u00a0<\/span>group by clause. A rate is the interest rate per period. <\/span><\/p>\n
The result has a default number format of money. All payments discount base on a 365-day year. Text values, null values and missing values in any or both pieces of a data-pair will result in the entire data-pair to disregard.<\/span><\/p>\n
Example:<\/b><\/span><\/p>\n
Load Year, npv(0.05, Payments, PayDates) as PValue from abc.csv group\u00a0<\/span>by Year.<\/span><\/p>\n
So, this was all about QlikView Aggregate Function. Hope you like our explanation<\/span><\/span><\/p>\n
Conclusion<\/h3>\n
We have covered almost all of the QlikView aggregate function. As you must have noticed aggregate functions covers wide range of fields, from basic mathematical functions to statistical and financial. Practice and learn to use these functions by applying it on your data records.<\/span><\/span><\/p>\n
If you have any doubts regarding QlikView Aggregate Function or want to know about more functions, let us know in the comment section below.<\/span><\/span><\/p>\n
Related Topic –\u00a0\u00a0QlikView Publisher Repository (QVPR)<\/a><\/strong><\/p>\n
Reference<\/a><\/strong>
One of the very useful functions amongst the long list of functions that we saw in the previous tutorial is QlikView Agg() Function category. In this QlikView Aggregate Function, we are going to gain...<\/p>\n","protected":false},"author":6,"featured_media":38863,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17375,17370,17372,17374,17377,17371,17369,17376,17373],"class_list":["post-38843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-advanced-aggregation-functions","tag-aggregation-function","tag-basic-aggregation-functions","tag-counter-aggregation-functions","tag-financial-aggregation-functions","tag-qlikview-aggr-function","tag-qlikview-aggregate-function","tag-statistical-aggregation-functions","tag-string-aggregation-functions"],"yoast_head":"\nQlikView Aggregate Function - 6 Types of AGGR() Function - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Aggregate Function - Types of AGGR() Functions in QlikView,Basic Aggr function,String,Counter,Advanced,Statistical,Financial Aggregation Functions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Aggregate Function - 6 Types of AGGR() Function - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Aggregate Function - Types of AGGR() Functions in QlikView,Basic Aggr function,String,Counter,Advanced,Statistical,Financial Aggregation Functions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-10T06:42:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Aggregate Function - 6 Types of AGGR() Function - DataFlair","description":"QlikView Aggregate Function - Types of AGGR() Functions in QlikView,Basic Aggr function,String,Counter,Advanced,Statistical,Financial Aggregation Functions","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Aggregate Function - 6 Types of AGGR() Function - DataFlair","og_description":"QlikView Aggregate Function - Types of AGGR() Functions in QlikView,Basic Aggr function,String,Counter,Advanced,Statistical,Financial Aggregation Functions","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-10T06:42:05+00:00","article_modified_time":"2021-12-07T05:50:25+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Aggregate Function – 6 Types of AGGR() Function","datePublished":"2018-11-10T06:42:05+00:00","dateModified":"2021-12-07T05:50:25+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/"},"wordCount":2432,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg","keywords":["Advanced Aggregation Functions","Aggregation Function","Basic Aggregation Functions","Counter Aggregation Functions","Financial Aggregation Functions","QlikView Aggr () Function","QlikView Aggregate Function","Statistical Aggregation Functions","String Aggregation Functions"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/","name":"QlikView Aggregate Function - 6 Types of AGGR() Function - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg","datePublished":"2018-11-10T06:42:05+00:00","dateModified":"2021-12-07T05:50:25+00:00","description":"QlikView Aggregate Function - Types of AGGR() Functions in QlikView,Basic Aggr function,String,Counter,Advanced,Statistical,Financial Aggregation Functions","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Aggregate-functions-01.jpg","width":1200,"height":628,"caption":"QlikView Aggregate Function - 6 Types of AGGR() Function"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Aggregate Function – 6 Types of AGGR() Function"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38843"}],"version-history":[{"count":12,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38843\/revisions"}],"predecessor-version":[{"id":104965,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38843\/revisions\/104965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38863"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}