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...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di... -
To connect a QlikView server (QVS) each client needs a CAL (client access license) The CAL’s are purchased with QlikView Server and tied t...
-
No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables
-
ODBC, OLEDB, SAP connectors
-
1st Tier - Raw data is getting loaded and QVD is creating. 2nd Tier - QVD is transform in the business login and requirement of the bus...
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
0 Comment to "Explain Aggr function?"
Post a Comment