Returns a set of values of expression calculated over dimension
Ex: Aggr(sum(sales), country)
Ex: Aggr(sum(sales), country)
Thursday 27 August 2015
Subscribe to:
Post Comments (Atom)
Weekly
-
QlikView provides a feature called Autogenerate which use for generate data using system’s programming. Using Autogenerate, QlikVie...
-
Keep: it will not join two tables and they will be stored in QlikView as two separate named tables. Keep will always preceded by one of th...
-
Optimized load is much faster and therefore preferable, especially for larger data sets. Optimized loads are possible if no transformations...
-
ODBC, OLEDB, SAP connectors
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables
-
The architecture is based on site concepts. It is a combination of one or more node connected to a common repository or central node. Ql...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di... -
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
-
Binary load is used only for one application means you are able to read data from only one QVW application and on the above of the set scr...
0 Comment to "Explain Aggr function?"
Post a Comment