QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Max count across a single dimension

by on Latest post on by

7 Replies 852 Views

7 Replies

852 Views

What is the fastest way to get a max value in a gr...

by on Latest post on by

9 Replies 1565 Views

9 Replies

1565 Views

Returning a value of the max number in a table

by on Latest post on by

2 Replies 305 Views

2 Replies

305 Views

find the percentage completed based on two tables

by on Latest post on by

1 Reply 256 Views

1 Reply

256 Views

Mark only highest value under a limit - background...

by on Latest post on by

14 Replies 1079 Views

14 Replies

1079 Views

Aggr()

by on

0 Replies 294 Views

0 Replies

294 Views

Subscribe by Topic

"error" 1
"windows tags" 1
$(field) 2
$expansion 1
$field 2
$Info 1
% 1
% Year over year( YoY) 1
%datapoint 1
' - ' 1
' null value' 1
'' 1
'break line' 'chr' 'replace' 1
'data model' 1
'matrix' 1
'MMM' 1
'null' 1
'peek''do while loop''variable' 1
'pivot' 1
'Qlik Sense' 1
'set analysis' 1
'set expressions' 1
-2 1
-3 1
. 1
.bat 1
.shared file issue 1
.txt 1
0 values 1
0 valure 1
1) 1
100% Stacked Bar Chart 1
1067 code error 1
12.10 1
12.4 3
12.40 4
15 minutes 1
1900 1
2 dimensions on X-Axis 1
2 tables 1
2 values 1
2.Customers 1
2021 wrong week for weekname(date) 1
2tables 1
3 month rolling average 1
3.Country 1
3quarters 1
4-4-5 1
4.Branch 1
443 1
445 calendar 1
5-4-4 financial year 1
5.Sales and my Another Source Data in . CSV File 2018 Sales my Requirement is Concatenate 2018 Sales Data.csv file data to Sales Table. 1
80th Percentile calculation 1
<> 1
@bill_markham 1
@datamodelling 1
@Gysbert_Wassenaar 2
@Henric_Cronström 1
@hierarchy 1
@Jagan 2
@kiranmanoharrode 1
@MarcoWedel 1
@marcus_sommer 1
@Oleg_Troyansky 2
@PavanNallani 2
@PDF_in_Qlikview 1
@qlik sense 1
@qlikview 6
@rubenmarin 1
@rwunderlich 2
@rwunderlich @marcus_sommer @Oleg_Troyansky 3
@Set Analyis 3
@sunny_talwar 27
@sunnytalwar 3
@Taoufiq_Zarra 5
@wassnarr 1
a 1
AAS 2
abbreviation 1
ABC analysis 1
Able to unhide a table when selecting any filter 1
abort 1
abort task 1
above 17
above value 1
above() 3
Above() function 11
above() in bar chart 1
above() in linechart 1
absolute value 1
Access 1
Access Database 1
Access Denied 2
Access Denied While exporting chart to network shared folder 1
Access Null data Values in qlikview 1
Access Point 23
Access Point - Qlik View 2
Access-point 4
accesspoint 9
accumulate 3
Accumulate but Different 1
accumulate sum 1
accumulated 1
accumulated sum 4
accumulates 1
Accumulation 14
accumulative line in combo chart 1
Accuracy 1
achsis 1
action 3
Actions 15
activate object 1
Activate Sheet 1
Active - Active QVS and QVWS 1
Active Directory 3
Active employees 1
ActiveDocument 1
Actuals 1
actuals vs budgets with mixed granularity 1
acumulación 1
acumulado 1
acumulados 2
acumulated expressions 1
AD 2
ad hoc report 2
add 2
add column 1
add data 1
add dates to existing table 1
add expression veritically 1
Add new rows to an existing column 1
Adding previous rows values in pivot of qlikview 1
adding text 2
addition 1
AdditionalColumninExcel 2
Addmonths 5
adhoc report issue 3
Admin 2
Administrator 1
Advance scripting 2
Advanced Aggr 2
Advanced Authoring 1
Advanced Data Visualization book 1
Advanced Pivot Tables 1
Advanced qlik 2
Advanced Qlikview 2
Advanced Search 1
advanced set analysis 6
AdventOfCode 1
aesthetics 1
age 4
age formula 1
agent 1
aggr 65
Aggr and Average - Syntax 1
aggr and null handling 1
Aggr Count 1
aggr function 8
aggr if 1
AGGR in set analysis 6
Aggr or Set Analysis 11
Aggr Sum 6
AGGR() 94
AGGR() ordering 1
Aggr. Function 5
aggregate 22
aggregate count 1
aggregate sum 1
aggregated 1
aggregated data 3
aggregated sum in matching fields 1
aggregating data 4
aggregating grouped dimensions 1
aggregating seconds field into hour field 1
aggregation 30
aggregation function 2
Aggregation in script 4
aggregation in set analysis 1
Agregate 1
agrupar 1
agrupar saida 1
Ajax 7
Ajax Accesspoint 2
AJAX and IE 2
ajax scroll mouse wheel 1
Ajax URL 2
Alarm 1
alert 3
alert qlikview 2
Alert wizard 3
alerts 2
Alex00321 1
Alias 1
aligment 2
align 1
alignment 2
Alignment issue 1
all 1
Allocated Memory Exceeded error in Pivot table 1
allocation 1
Allow dynamic CAL assignment 1
allow-nonselect-queries 1
alphabetical 1
Alphanumeric 3
Already Have Variables for Year and Month in the Dashboard 1
Alt 2
Alternate rows 1
Alternate set 1
alternate state 6
Alternate States 30
alternative measure 2
Alternative state 2
Alteryx 1
always one selected 1
always one selected value 3
always_one_selectedalways_one_selected_valuefrom_and_to_weeklist_boxesoptionpropertiesset_analysisvariableweek_analisys 2
amortization 1
amount 2
amounts 1
Ampersand (&) 1
ANALISIS 2
analitics 2
Analysis 7
Analytics 5
analyzer 2
Anaplan 1
and 7
And filter 1
AND logic 2
andor 1
angle brackets 1
animate 2
Animated chart 1
animated graph 2
Animated scatter chart 1
animation 4
Annee 1
Announcements & Events 2
anomalies values 1
anonymisation 1
any 1
análisis 1
API 8
API autentication 1
APIs 4
app 1
App contents 1
App Crash 1
App Design 4
App Development 47
App Size 1
Apple Mac 1
appli 1
application 3
Application access issue 1
Application Development 1,728
Apply 1
apply map 3
applymap 21
Applymap() 12
Approximate Match 2
approximate string match 1
aprender 1
April 2019 3
April 2019 IR vs SR 1
April 2019 SR3 1
arbitrary 1
Architecture 1
Archive 1
archivo 1
area 1
argb 1
ARPITWIZ 1
array 3
array type data load data base 1
arrg 2
arrow 1
Arrow Object 1
As of table 1
ASCII NUL 1
asd 1
asdas， 1
asignacion 1
asignación 1
asof 2
assemblies 1
assign custom title for field values in qlik view 1
Assign one Row to multiple Filter Options 2
Associate 1
associated keys 1
Association 1
Associative 2
Atribui um texto especifico a valores nulos 1
attach report 1
attached 1
Attachment 1
attributes 2
augorenerate name from variable 1
Authenticate.aspx 1
authentication 1
Authentication API 1
authorization 1
AUTIMATED_TESTING 1
auto generate 1
Auto Refresh 1
auto-converting data type 1
autocomplete 1
Autofit Coloumns in Excel 1
autofit screen 1
autogenerate 5
AutoGenerate number 1
Autoincrement 1
Automate 1
automated export 1
Automated Testing 1
automatic 1
automatic adjustment 1
automatic run 1
automatically 1
Automatically quarentine doc cal 1
Automation 5
automise 1
autonumber 5
autonumber() 4
Autorefresh Dashboard on big TV screen 1
autoscaling 1
aux varibles. 1
available value 1
average 24
Average Calculation 3
average calculations 3
average formula 2
Average Metric Calcualtion 1
Average Trendline 3
average value 1
averages 1
avg 10
Avg Function 3
avg() 4
avoid 1
AWS 3
axis 13
axis color 1
Ayuda 4
Azure 2
Azure Cloud 2
AzureAnalysisService 2
back fill 1
background 3
background color 16
Background color for missing value row 1
Background color In pivot table 1
background colour 3
background expression 2
background image 1
backgroundColor 1
backgroundcolorexpressions 1
backroundColor 1
backup 1
bag 1
balance 2
Balance sheet 1
Banding 2
bankaccount 1
bar 5
Bar char 2
bar chart 56
bar chart expressions 9
Bar chart sort 1
Bar Chart with Month and Year 3
Bar chart with values 3
Bar charts 15
Bar charts expressions 3
bar colours 1
bar graph 2
bar offset 1
barchart 19
BarLegendOverlapping 1
Bars 1
Bart chart with a filter of selection 1
base 16 format 1
base map 1
Based on min value of seq number for Key 1
based on Sample work data Need output as below 1
based on selection previous years data 1
BasesDeDatos 1
Basics 2
Basket analysis 1
bat 2
batch 6
before 1
beginner 3
beginner help 1
beginning balance 1
Bell chart Normdist 1
below 1
Benchmark 2
Benchmarking 1
best before date 1
best practice 1
Best Practices 1
between 7
between two dates 3
BI 1
Big Data 1
Big File Size 1
big picture 1
bigdata 1
biggest 1
bigquery 1
billed 1
binary 2
binary excel file 1
binary format 1
Binary Load 4
binary number 1
bit 1
Bitand 1
blank 5
Blank Chart 1
blank fields 1
blank objects 1
Blob_to_Text 1
block chart 2
blog 1
bnf 1
bold 2
BOM 3
bonus 1
bookmark 7
Bookmark creation 1
bookmark Issue 1
Bookmark Trigger 2
bookmark vbscript 1
Bookmarks 13
Boolean 2
boolean script chart restrictive 1
borders 5
Both and 1
Boton 2
bottom 1
box chart 1
Box Plot 2
boxplot 2
bracket v12 1
Brasil 1
broken community editor 1
Browse_for_File 1
browser 2
bubble 2
bubble size 1
Bucket 4
Bucketing 3
buckets 1
bug 12
bug wildcard binary load 1
Bugs 1
Bugs & Errors 16
bugs in 12.4 2
BULK 1
Bundle 3
buscarenew 1
Business Analyst 1
Business Intelligence 1
businesshours 1
button 10
button action 2
Button Actions 5
Button to select Cases 1
Button to select Field 7
Button to switch betweeen languages 1
ButtonActions 3
buttons 9
Bypass Filter 1
búsqueda 1
Cache 3
CAL 3
calander 1
calculate 2
calculate between periods 1
Calculate dimension 1
calculate load 1
calculate Opening and closing Count 1
Calculate percentage 1
Calculate Sequence 1
calculate total with variables 1
calculated 2
Calculated Color 1
calculated column 2
calculated columns 1
Calculated date 3
Calculated Date Dimension 2
Calculated dimension 41
Calculated dimension assistance 1
Calculated Dimension Colors 1
calculated dimension issue on pivot table 2
calculated dimensions 19
Calculated expression 1
calculated field 10
calculated fields 1
calculated periods 1
calculated_dimension 1
calculation 13
Calculation based total amount find the Usage 2
calculation between rows 2
Calculation Condision 1
Calculation Condition 7
calculation time out error 2
calculations 5
calculo 1
calculte amount of time in minutes 1
calendar 35
Calendar Control 1
calendar script 6
Calendar table 1
calendarweek 1
Call 1
Cals 2
campare 1
Campo 1
campo nulo 1
campos 2
can someone give some hint please 1
can't open qvw 1
Cannot open file 2
canonical calender 1
Canonical Date 3
CanonicalDate 1
caption 2
caracteres especiais 1
CARGA 4
Carga de arquivo QVD para consulta de arquivos de BI 1
carpeta 1
CarriedForward 1
carryforwardsrequest 1
cartesian 2
case 4
case insensitive 1
Case Statment in list box 1
Case Study 2
CAST 2
category 1
ceiling 1
cell 2
cell format 1
cell formula 1
cells 2
cellvalue 1
center label 1
centralization 1
certification 2
Chaining 1
change 1
change color of the legend in bar or line chart 1
Change in Sales 1
change selection 1
Character liimitation on search values 1
Character Set 3
CharacterMatch 1
Chart 60
chart aggr dimension pop-ip 1
Chart bar 10
chart expression 7
chart expressions 7
chart function 3
chart functions 1
Chart ID 1
Chart in QlikView 13
chart labels incorrect dimension 1
Chart Object 23
chart properties 4
Chart reference lines 1
chart selections 1
ChartOverlapping 1
charts 29
Charts Select 3
chat 2
check 2
check file exists 1
Checkbox 2
Chess 1
chi squared 1
chr(10) 1
chr(13) 1
chr(39) 1
chrome 2
circular loop 2
Circular reference error 1
cisco webex connector 1
class 3
CLAUSE 1
Cleanup 1
clear 2
clear all 1
clear fields 1
Clear one selected field value based on variable selection 1
clear state 1
ClearAllTrigger 2
ClearFields 2
click twice 1
Client Managed 210
clock 1
clone 1
Closing 1
Closing_Employee 1
cloud 2
Cloud Business 1
Cloudera 1
cluster 3
Cláusula 1
CMD 2
COALESCE 1
Code 1
CODES 1
coding 4
cohort 1
Collapsible Dimension 1
colon 1
Color 26
Color background in pivot table 1
Color by area 1
color by dimension 1
Color by dimension value in qlikview 2
color by expression 1
color change 1
color change of text value inside dropdown 1
color code based on age 1
Color code Map based on categories 1
Color coding 2
Color Coding Logic for Pivot table 1
Color condition error 2
color expression 1
Color selection is locked 1
colorcode 1
colorexpression 1
Colorexpressions 1
ColorMix 5
colormix background colors 1
colormix pivot totals 1
colormix2 1
Colors 8
colour 5
colour by expression 2
column 14
column dimension 2
column headings 1
Column labels 2
column order 4
Column Set analysis 1
column title 1
column to variable 1
column total 1
column() 1
columnas 1
columns 9
columns change 2
columns dynamically from excel sheets 1
columns Filter 1
Columnsasdates 1
columnwise 1
colur 1
combinación 1
Combination of Budget and Actuals 1
combine dimensions 1
Combine fields 9
Combine pivot tables 1
combine QVD 1
combine strings 1
combined chart 1
combining 1
combining formula 1
combining tables 1
combo 1
Combo Chart 22
combo charts 3
comma 2
comma separated 2
COMMAND 1
command line 2
comment 4
comments 2
Commercial Year 1
Common calendar 1
Common time dimension 1
Community Help 41
community launch 1
COMO SACAR MEDIA 1
comparacion 1
Comparation 2
COMPARATIVE 1
comparative analysis 1
Comparative two numeric columns 1
compare 7
compare 2 fields in same table 2
Compare date 1
Compare Dates in between in another column 1
Compare fields between two tables without having a common column 1
compare fields script 4
compare sales from two tables 1
Compare updated data in a field 1
Comparing Dates 2
comparing periods 1
comparison 8
comparison between months 1
comparitive analysis 1
completeness 1
Complex Cross tab file processing 1
complex measure 2
complex requirement 1
Composite FROM 1
composite key 2
composite keys 1
Compute 1
Concat 21
Concat on two generic fields 1
Concat value 1
Concat() 6
concatenade field values into string 1
concatenate 26
Concatenate 2 Fact tables 3
concatenate expressions 1
Concatenate fields 3
Concatenate more rows to one row 2
Concatenate sort bug 1
Concatenate x Lef Join 1
concatenated 1
Concatenating data 1
concatenation 2
conctenated fields 1
condition 9
Condition Minus Greater 1
condition text object 1
conditional 11
conditional collor 1
conditional colors 1
Conditional Column 3
Conditional Date Format 1
conditional dimension 5
conditional display 3
Conditional Display of Measures 1
conditional expression 2
Conditional Expressions 8
Conditional format 1
Conditional formatting 10
Conditional formatting in Qliksense 1
Conditional images 1
conditional load 3
Conditional Row No 1
conditional show 4
Conditional show listbox 1
conditional statement 1
Conditional statements 1
conditional sum 4
conditional sum with variables 1
ConditionalExpressions 12
Conditioning error 1
Conditions 4
condtional 1
conection 1
conector web 1
conexão 1
config 1
Configuration 4
Confused what could be wrong 1
conn 1
connect 2
connected 1
connection 5
connection error 1
connection path 1
connection string 1
Connection to Oracle 1
connections 1
Connectivity 2
Connector 4
Connectors 3
consecutive differences 1
consecutive quarters calculation 1
consecutive targets 1
CONSISTENT 1
console 1
consolidate 1
Constant 1
consumption 1
contain 1
container 7
Container Pivot Table export to Excel 1
containers 3
contains 1
contar 1
conteo semanal 1
continuous variable 1
Contract 1
contro de acceso 1
control-flow 1
conversation 1
Conversion 4
convert 4
Convert field value which starts with text or some special characters into 'NLL' 2
convert if to set analysis 1
Convert qlik code to SQL 1
Convert Qlikview obj to json 1
convert snowflake schema into star schema 1
convert straight table 1
Convert table columns into hierarchical structure 1
Convert Unix epoch date time into normal date and vice versa 1
Converting IF condition to Set Expression in qlikview 1
converttolocaltime 2
Cookies 1
copy sheet 2
copy text 1
Copy Value 1
Copying data 2
correl 1
Correlation 2
Correlation With Repeat Price 1
Corrupt 2
Cost 1
Count 87
count aggr 2
Count Aggr If 3
Count clarification 1
Count Data Like COUNTIF in Excel 1
count distinct 5
count distinct id 2
Count Distinct if 1
Count if 11
Count if condition 4
COUNT if two conditions 3
Count in Qlikview script 1
Count of distinct with set analysis 2
count of division calculation 1
count of sum 1
Count one Single column on the basis of other Single column & single variable 1
COUNT Parameters 17
Count the number of leave days from start and End date and Exclude the weekend day. 1
COUNT UNIQUE OCCURENCE 6
Count with If condition 3
count() 1
Count_days 1
Countif 4
counting 1
countrecords 1
Country Code 1
cpu 1
create 5
Create a column with weekdays and All days 1
create a customised field 2
Create a Dimension-Pivot Table 1
Create Bandings 1
Create Dates 1
create excel 1
Create Expression from different tables 1
Create Line chart by using data as how many times user visit on website 1
create new table less than target sequence number 1
create objects 1
Creating Analytics 707
creating bookmarks 1
creating table 1
criterio 1
Critical trouble 1
Cross Tab 2
Cross Table 8
cross tables 1
Crosstab 2
crosstable 18
CrossTable -Lable Date 1
Crosstable does not help 1
CrossTable format in qlikview 1
Crosstable multiple columns 1
Crosstable multiple rows 4
CrossTable with multiple columns 1
crosstabs 1
css 1
CSV 11
CSV_source 1
cte 1
CTTA01+TOTTRANS)) 1
CTTA01-TOTTRANS 1
Cummulative 4
cummulative sum 3
cumulation 3
cumulative 12
cumulative % 1
Cumulative calculation using range sum function 6
cumulative count 1
Cumulative Horizontal 1
cumulative sum 3
cumulative sum in chart 2
Cumulative sum in straight table 1
Cumulative summation by date 4
Cumulative summation by dimensions 2
Cumulative total 1
cumulativesum pivottable qlickview expression 1
Currencies 2
Currency 2
Currency Rate 1
current month 2
Current Quarter Sales 1
Current Selection 7
Current Selection box 1
current Tablename 1
CURRENT TIMESTAMP 1
Current Year 2
currentfieldexpression 1
currentfieldselected 1
currentselection 1
CurrentSelections 2
Currentyearbydefault 1
Curso 1
cursor 1
curve 3
custom 2
Custom Color 1
Custom error messages 1
Custom List Box 1
custom pivot 1
custom sort 2
custom sorting 1
custom totals 1
customer 2
Customer Value 1
customers 1
Customization 1
customsel 1
cycle group 2
cyclic dimension 1
cyclic group 4
cyclic group cumulative sum rangesum 1
Cyclic Group Dimension 4
Cyclicgroupexpression 2
Cálculo de Percentual 1
cálculo dimensão calculada percentual 1
d3 1
d3.JS 1
DADOS 1
DailyQVD 1
Dashboard 23
Dashboard in access point 1
dashboard issues 2
data 26
data across dimensions 1
data aggregation 2
Data Analytics 5
Data base 1
Data Catalog 1
data checks 2
data cleansing 1
data comparison 1
Data Connection 1
data connections 1
data connector 2
data converting 2
Data Dictionary 1
data discovery 1
Data Extraction Issue 2
data filtering 1
Data Governance 3
data import 1
Data inconsistancey in Qlik Script and SqL script 2
data labels 1
data load 7
Data Load Editor 5
data loading 3
Data Manipulation 2
data mapping 1
Data matching 1
data minima 1
data mining 1
Data Model 18
Data model Issue 2
Data model viewer 1
data modeling 4
Data Modelling 17
data point 1
Data Prep 1
Data Preparation 1
Data Presentation 1
DATA REDUCTION 1
data refresh 1
Data Science 4
data series 1
Data Storage 1
data storing 1
data table 1
Data table with chart 1
data transformation 1
data type 3
data upload 1
data validation 1
Data values overlap 1
data visualization 2
data_loading 2
database 5
database connection settings 2
database connnection 2
database information table 1
Database Query 2
Database Update 1
databetweentwodates 1
dataisland 1
Datamodel 6
datamodel logic 1
Datamodel should get refresh data on every reload 1
datamodeling 2
Datapoints 1
datarestriction 1
DataSet 1
Datasource 1
datatype 1
Date 149
Date & Time 13
date bridge 1
Date Bucket 3
date calculation 3
date comparison 4
date conversion 3
date convert 4
Date converting 9
date difference 1
Date Expression 1
date field 6
date field value 2
date fields 1
Date filter 9
date format 13
Date format wrong. 2
date formatting 3
date function 2
Date Functions 8
date in for next 1
date interval 1
date limit 1
Date Links 2
date null sqlserver 1
Date Order 3
date picker 1
Date Picker. 1
date qlik doubling time script function 1
Date Range 19
date range date leadtime 1
Date range picker extension 1
Date ranges 5
Date selection 4
date system 1
Date time 1
Date Time interval 1
date time timestamp 1
date timestamp 1
DATE VALUE 33
Date Variable 4
date variables 1
Date_Missing 1
datediff 1
datefield 1
DateFilter 2
DateFormat 2
DateFormatting 2
dates 41
dates between 2
dates comparison 8
Dates differenece in days 1
Dates Help 8
datestamp 1
datetime 3
Datetime Calculation 1
DateTime handling 1
datetime stamp transformation 1
DateTimeformat 4
datos 2
Datum 5
DAX 2
Dax Query 1
day 1
day on day 1
daymonth 1
DayNumberInQuarter leap year 1
days 3
days input 1
days past date calculation 1
DB connection 1
DCom 1
deafults 1
deatached 1
debug 2
decimal 1
decimals 7
declare 1
default 4
Default Filters 1
default mapping 1
default selection 1
Default Settings 1
Default to max date where max date is a business day 1
Default value selection from List box 1
defaults 1
delay 1
delete 5
delete file 1
DELETE method 1
delete row 1
deleting bookmarks 1
Deleting values 2
delimiter 3
Delimiters 8
Demension 1
demerits 1
demo 1
Deployment 47
design 9
Design PDF as per client requirement 1
Designer 7
designing 5
Desktop 3
desktop client 1
detach 1
Detailed Drill Down 1
Developer 21
Developer license 1
Developer Toolkit 1
Developers 5
Development 31
deviation 1
diagram 4
Diagramm 1
Dictionary 1
difference 6
Difference between Concatenate and ApplyMap Where we use give me an example 1
Difference Between Dates 1
Difference between Join and Applymap 1
Difference between keep and Join where we use give me an example 1
Difference between match and mixmatch function where we use give me an example 1
Difference between Peek and Pick Function give me an example 1
Difference between Peek and Previous Function give me an example 1
Difference between Synthetic Tables and Circular loops give me an example 1
difference between tables 1
Difference between to dates in years and months 1
Difference between Variable and Master Calendar give me an example 1
different columns 1
different delimiters 1
Different font and style in qlikview text object 1
different granularity 1
different periods values 1
different tables 1
different values 1
Difficult Logic 1
digits 1
dim 2
DimensaoDistinta 1
dimensie 1
Dimensiom 2
dimension 47
Dimension as expression 7
Dimension ascending of Fiscalyearquarter 1
Dimension axes 5
dimension counting 1
Dimension grouping based on another dimension 1
dimension ignore filters 1
dimension in pivot 3
Dimension labels 4
dimension limit 7
dimension limit in a pivot 1
dimension limits 2
dimension set analysis 1
dimension values 1
dimensional scope 1
Dimensiones 2
DimensionLimit 2
Dimensions 73
Dimensions as Measures 1
Dimensão 1
Dimensão Calculada 2
dimesao 1
dimesions 2
Dimesnion % Calculation 1
dirección 1
Direct Discovery 2
Direct Discovery Issues 1
Direct Query 1
directory 1
Directory Service 1
Directory Service Connectors 1
DirectQuery 1
disable repository 1
Disaster Recovery machine 1
discount 1
diseño 1
display 1
Display data 1
Display date range 1
Display dimension 1
display field based on other data 1
Display label 1
Display New customers Year on Year 1
Display values 2
Display values in straight table 2
displaying multilines in qlikview 1
distance 2
Distinct 24
distinct count 2
distinct counts 1
Distinct List 1
distinct sum 1
Distinct values 7
distribute 1
distribution 3
distribution plot 1
Distribution Services 1
divide 4
division 3
Division by Variable 1
DLP 1
do loop 2
do not open 1
do not show null 1
do not sum 1
do while 2
Do While Loop 2
Doc Cal 2
DocAnalyzer 1
Document 4
Document Analyser 1
document CAL 1
Document Chain 5
document chaining 3
Document chaining In Qlikview 6
Document Information 2
document open 1
document properties 2
Document Report 1
Documentation 4
documentname 1
DocumentPath() 1
Documents 1
DOD 1
doesn't exist 1
doesn't null value 1
Dollar expansion 4
Dollar Sign 3
Dollar sign expansion with variable with & operator 1
Dollarexpression 2
Domain Migration 1
donut chart 1
dots 1
double 1
double counting 1
double dagger 1
Double Dimension 1
double mapping 1
Double Quotes 1
Double values in a Statistic Box 1
doubt 1
Doughnut 2
Download 3
download-old-version 1
Downloads 2
DragDrop 1
drill down 2
Drill-Down 2
Drill-Down Bar Chart 1
drilldowndimension 1
Driver : MS-Access Driver[*mdb.*accdb] 1
DriverOAuthSupport 1
drop 1
drop box 1
drop down 1
drop down menu 1
drop down select 1
Drop fields 1
Dropdown 1
Dropped Fields 1
DSC service 1
dual 3
dual data type 2
Dual Set Expressions 2
Dual Use 1
duplicate 7
Duplicate data 5
duplicate fields 2
Duplicate Rows 6
duplicate values 1
Duplicated Labels 1
duplicated records 1
DuplicateID 1
Duplicaterecords 7
duplicates 11
duplicates rows duplicates records 1
duration 3
Duration calculation 1
duvida 1
dynamic 7
Dynamic Assignment 1
Dynamic Charts 5
Dynamic comparison 1
dynamic date expression 1
dynamic delete 1
dynamic dimension 4
dynamic dimension limits 2
dynamic display image 1
dynamic expressions 1
dynamic field name 4
Dynamic FilePath 1
Dynamic filter 1
dynamic filter variable ranges 1
dynamic filters 1
DYNAMIC FORMULE 1
dynamic intervals 1
Dynamic Reference Lines 1
Dynamic selections 6
dynamic set analysis 1
dynamic set modifier 1
dynamic table 2
dynamic tables 1
Dynamic triggers 1
dynamic update 1
Dynamic value 1
dynamic variable 2
Dynamic views 1
dynamically from excel sheets 1
DynamicColumns 3
DynamicFilter 2
dynamicUrl 1
Dynmaic button 1
e 2
E() 1
Earliest value for the day 1
easy 1
EC2 2
edit 1
edit expression 2
Editing 2
editing tabs 1
education 1
EDX tasks 1
EERR 1
EffectiveDate. 1
efficiency 1
elapsedtime 1
else 1
email 6
email address 1
email alert 3
email config 1
email URL 1
Embed 1
embed labels 1
emojis 1
EmpCount 1
Employee_No 1
empty bars 1
empty fields 1
empty values 1
Enable Conditional 2
End 1
end date 1
End user statistics 1
enddate 4
endif 1
ending balance 1
Engine 1
enterprise 1
Entitlements & Permissions 35
Entity Report 1
Entries 1
epic 1
equal to date 1
equals 2
erro 1
error 20
error expresión utilizando signo > 1
error file 1
error handling 2
Error in Calculated dimension 1
Error in qmc app while running in qmc 1
Error Load in Qlikview November 2018 3
Error Loading fies 1
Error Message 1
Error Messages 3
Error: field not found 1
errormode 1
Errors - Unexpected Behavior 6
Errors in Qlikview dashboard while running 1
estado de resultados 1
etiquetas 1
ETL 3
Europe KML file 1
evaluate 1
Events 2
every data row 2
excel 31
Excel data 21
Excel data sets to Qlik 5
Excel Export Logs 1
Excel export missing headers 1
Excel Exports 17
excel file 1
Excel file download 1
excel functions 1
Excel load to Qlikview 2
excel loading 3
Excel pivot data into qlikview 1
Excel Pivot table 1
Excel query 1
excel script 1
excel sheets 1
Excel via ODBC 1
excel worksheets 1
ExcelSource 2
excercises 1
exchange Rate 1
exclude 4
exclude data 2
excluded 1
excluded selections 1
Excluded Values 9
ExcludedValues 1
Excluding data on LOAD in EXCEL 1
Excluding Selections 2
exclusion 3
executable 1
execute 3
Execute Command 1
Execute Command in Script 2
execution failed 1
Execution of Script Failed 1
Exists 12
Exists() 1
exit script 3
Expand 3
Expandissue 1
expansion 1
Expansão $ 1
ExpDate 1
Explicit Labels issue with excel 1
Export 17
export api 1
Export as unicode txt format 1
export bitmaps 1
EXPORT CSV 3
export data 2
export delimited file 1
export error 1
export excel 1
export excel file 1
Export ExportEx Excel Qlikview Server 1
export image 1
export ppt 2
Export Script 2
export to csv 1
export to excel 1
export to image 1
exportar 1
Exporting Current Selections to excel 1
Exporting data 4
exporting multiple tables from QV to Excel 1
exporting to csv 1
expresion 2
expresiones 1
expresison 1
expression 241
Expression Axis 1
Expression builder 4
Expression Challenge 5
expression editor 1
Expression Error 18
expression for rolling six months 1
expression in script 2
expression syntax 2
Expression Total 8
Expression value selection in to dimension 1
Expression with (Min) 1
ExpressionColors 4
Expressions 76
expressions straight table 8
expressions sum not null multiple field conditions 1
Exprssion 1
extend line 1
Extension 2
Extension Objects 4
Extensions 1
External 2
external data 1
extra dimension 1
ExtraCharacters 1
Extract 7
Extract Date from String 1
extraction 2
Extractor 2
FABS 1
FABS in set analysis 1
Facebook 1
fact table 3
Fact tables 1
Fail 2
fail to load 1
failed 2
failed to load 5
Failed to open 1
Failed to open document for unknown reasons 2
failover 1
falha ao abrir qvw 1
False() 1
February 2019 1
Fecha 3
Fechas 2
Fetch dimension value 1
Few sheet properties missing in access point 1
field 16
field as variable 2
Field Event Trigger 3
field list 1
Field Load 2
Field name 6
field not found 5
field not found error 2
Field renaming 3
field selection 2
field seletion 1
Field Type 1
Field value 3
fieldname 2
FieldNumber 1
fields 8
fields in a column of data 2
fieldselection 2
file 5
file exists 1
File name 2
File not found error 1
File Size 1
file size large 1
File wizard: Transform 1
file-format 1
FileList 1
filename 1
FileName() 1
filepicker 1
files 7
filesize 1
filesystem 2
Filetime 1
Filling Fields 2
filter 57
Filter applies 2 fields 1
Filter by Data Types 1
FILTER BY DATE 4
Filter condition +Condition Filter - Need help here 1
Filter condition in qlikview 2
Filter DataSource 1
Filter Date 6
Filter Dates 2
Filter dimension measure 1
filter duplicates 1
filter logic 1
Filter Null Values 1
Filter only on some data 2
filter pane 2
filter panel 1
filter selections 1
Filter tables data on condition 1
filter value 1
Filter Visualization 2
filtering 5
filters 13
filtro 2
Filtros 1
Financial model 1
Financial Tables 1
financial year 2
Find string 1
FindOneOf(RefIDWL 1
Firewall 1
first day 1
first sorted value 1
First value 3
FirstSortedValue 20
FirstSortedValue() 7
firstvalue 2
Firstworkdate 1
Fiscal Calendar 2
Fiscal Quaters 3
fiscal year 5
Five9 1
fixed 2
FIXED DIVISION 1
FIXED Position 1
fixed value 1
flag 10
flag count 1
FLAG Creation 3
flagging 1
flags 2
Flags in qlikview 2
flat file 2
flat table 1
flipping axis 1
float 1
float64 1
floor 6
foirmat 1
folder 3
FolderAccess 1
Folders 1
font 3
font color 1
fonts 2
for 2
for each 3
for loop 16
For loop file store 2
for next 4
Force selections 1
Forecast 7
forecast data 2
Forecasting 1
Forecasts based on 6 months data 1
Forecasts based on last year's figures for the next coming 3 months 1
format 13
format axis 1
format date 2
format error 1
format num 3
Format Specification Item 1
Formating 7
formats 1
formatting 17
Formatting Rules 4
formula 23
formula last year 2
formula sum 1
Formula working in Text Box but not in Pivot Table 1
Formular sum 1
formulas 1
Formules 1
fractile 4
Fractile Aggr Linest_b Linest_m Trendline 1
freeze 1
freeze pane 1
Freezes 1
freezing on sort properties 1
from 1
FROM statement 1
from_field 1
fromDate 1
Front End Help 1
front-end 1
FTP 1
full accumulation 1
full month 1
Full Outer Join 1
Función 1
function 20
functional analysis 1
Functionality 3
functions 7
funnel chart 1
função 1
Fuzzy search 1
FY20 1
Gantt chart 8
gaps 1
Gaps for purchased date of repeated customer 1
gauge 3
gauge chart 5
Gauge chart (street light) 2
gauge charts 1
gauge expression 1
gauges chart 1
general error 1
General Question 13
Generate an APP 1
Generate dates 3
Generate Logfile 1
generate missing data 1
generating data in QV 1
Generation 1
Generic calendar 1
generic key 1
generic keys 1
generic load 3
Generic Load. 2
genericexceiption 1
Geo analytic 1
geo analytics 1
GeoAnalytics 2
geocodes 1
geodata 1
GeoQlik 1
get 1
get percentage 1
Get TOTAL from the result of the other column 1
getcurrentfield 1
GetCurrentSelections() 1
Getfield Selection value not available 1
GetFieldSelections 11
GetPossibleValues 1
GetSelectedCount 2
Getting error when connecting from qlikview to Azure Database 1
Getting Started 1
getvariables 1
github connector 1
give some examples 1
go to other tab on object click in straight table in qlik view 12 1
Google Big Query 1
google map 2
Google Maps 3
Google Maps API 1
Googleapis 2
GoogleMap 1
Googlemaps 4
Governance 2
governance dashboard 6
Governance Dashboard 2.1.4 1
gradient 1
grafico 1
GraficoCombinado 1
grain mismatch 1
grand total 3
Grand Total Issue 1
Grant 1
Graph 20
graph correlation 1
graphics 5
Graphs 7
greater than 5
greater than equal to 2
Green-COlorPreview 1
Greentree 4
Grid chart 3
Grid Chart Labels using Dual Aggr() 1
Grid sum 1
gridchart 1
gridlines 1
group 11
group by 27
Group by in Load 12
Group by Interval Time 1
Group by Invalid expression 2
GROUP BY ISSUE 7
Group Cells 1
Group data 1
group dimensions 2
Group Distribution Normal 1
group rank 1
groupby 2
Grouped Bar Chart 3
Grouped data 3
grouping 5
Grouping line chart 1
grouping values 1
Groups 3
Gráfico de Barras 1
Gráfico de Gantt 1
Guage in straight Pivot tables. 1
Gysbert_Wassenaar 1
has error bar 1
hash 1
hash algorithm 1
having count 2
Head count 1
headache 1
header 6
Header column Pivot 2
Healthcare 4
Healthcare Fractile Aggr Set analysis 2
help 9
Help ! 6
Help me Set Expressions 1
Help me to build Master Calender by useing period 1
help needed 3
Help required 4
Help required on Front End 1
Henric_Cronström 3
hh:mm 1
hi 1
hidden 2
hiddenscript 1
hide 8
Hide and show 7
Hide and show object 1
hide columns 1
hide excluded 1
Hide from access point 1
hide Listbox 1
Hide Prefix 1
Hide Quarter 1
hide rows 4
Hide Show button 1
hide specific values 1
Hide Values on x-axis 1
HideExpression 4
HIDEN 1
Hiden script 1
hiding 1
HidingExpressions 1
hierarchical 1
hierarchy 13
Hierarchy Dimension 3
highest sales 1
Highlight based two different set of tables and on field value 1
highlights 1
hint would be fine 1
Histogram 6
historic 1
historical interval 1
Hive 1
Hive Connection 2
holding page 1
holiday 1
Holiday Flag for Different Countries 1
HolidayList 1
Holidays 2
homepage 1
horizontal 1
horizontal line 1
hot key 1
Hotkey 1
hotkeys 1
Hour 2
Hourglass 1
hours 5
Hover. Help Text. 1
how many columns can visible in table based on selections in dimension in Adhoc Report 1
How to assign same values to Nulls which is having primary key in Qlikview script while loading 1
how to calculate amount based on discount % 1
How to calculate the first day of a different status 1
how to combine and show 2 columns from different table as 1 list box 1
how to connect data of google analytics to Qlikview 1
How to connect this Please Help 1
How to create next row in script 1
How to Create Master Calendar give me an example 1
How to Derive BirthDate to AgeGroup give me an example 1
How to develop an Application in the QlikView to send the SMS using VB Macro 1
How to Download Qlik Demo application 1
how to download qlikview 1
How to exclude dates 1
How to find min and max value 1
HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP 1
How to get same values in a row in qlilview 1
How to get the last used report date for NL user in QV 1
How to handle NULL comparion in qv scrpts 1
How to Install and connect Ms Access Database -2010- 64-bit 1
how to load huge data from oracle with insert and update !!! 1
how to load multiple qvds with different column and successful concatenation without synthetic keys 1
how to load qvds from folder where qvds should be last 6 months or less than 6 months any number 1
How to load qvds from last 8 months from specific days and concatenate each other 1
How to merge multiple rows into single row in qlikview 1
How to move the bars together and put them in the middle please 1
how to pass different select in field from common dashboard to other dashboard by document chaining 1
how to Remove synthetic keys give me an example 1
How to show all selected periods in Stright Table 1
How to show Average of Rows in Pivot Table 1
how to show duplicate record in dashboard 1
How to transform one by one data in list box 1
How to Transpose Need some help 1
HTML 5
HTTP 2
https 3
https access point 1
https redirect 2
hub 1
Hyper link 1
Hyperlink 5
Hypertext 1
I have one Excel Souce Data These are my sheets 1.Products 1
IBAN 1
ID 4
identical rank values 1
Identifiers 1
IE 1
IE Plugin 4
ie_plugin 1
if 35
IF & OR 12
IF AND STATEMENT 16
if clause 5
if condition 13
if condition with multiple values in Qlik sense 2
If else 6
If Else Expression 5
if else statment in list box 1
if expression 5
if function 2
IF Match 3
If match in Qliksense scripting 1
IF only 5
if sentence 1
If stament 16
if statement 39
If statement Date range Add Months LasRefresh 1
If statement exclusion 3
if statement in load script 1
if statements 3
if statements date 1
If statment 3
If then and else 3
If Then Condition 2
if-condition 1
if-statement 3
if-sum 2
If...ElseIf 1
If...ElseIf cause 3
IF...THEN 8
Ifcondition 2
iferror 1
ifthenelse 2
ignore 1
Ignore dimension 1
Ignore dimensions 1
ignore filter 3
ignore selection 1
Ignorebrackets 1
ignoredfilter 1
ignoring rows 1
ignoring selections 2
Illness buckts 1
image 4
Images 6
Images in Expression level 2
Imoprt Web Files. 1
Import 2
Important 1
Importing data script 1
imágenes 1
in month 1
in script editor 1
inbetween 1
inc load 1
Incline 1
include filters 1
Include Statement in qlikview scripts 1
IncludedValuesfirst 1
income statement 1
Inconsistency Error 1
Inconsistent results 1
Incorrect totals-Set Analysis 1
Increment 1
incremental 4
Incremental Load 22
Incremental Load on Date condition 2
IncrementalLoad 5
IncrementalLoadwithoutdatefield 1
incremetalload 1
indepenant selections 1
independant sheets 1
independent field 1
Index 4
index table 1
index-match-max 1
indexing 1
indicator 1
Individual 1
info 1
infoload 1
informes 1
IniData 1
inline 2
Inline Error 1
Inline Load 5
inline macro expansion 1
Inline Table 1
inner join 6
input 4
input box 8
input box objects 1
Input data 2
Input variable 1
inputbox 1
inputfield 3
inputfields 2
inremental qlik 1
Insert 7
insert from qlik 1
insert new row 2
insert row 1
insert with load 1
InsertUpdate 1
install 1
Installation 1
Installation - Upgrade 1
Instrument for Data flow 1
int 1
int64 1
Integer 3
integer series 1
Integration 7
Inter record functions 3
interest rates 1
interface 1
interfallmatch 1
Internal Server Error 1
Internet Explorer 1
Interpolation 1
interpreting 1
intersecting 1
intersection 4
interval 9
Interval Dates 4
Interval Match 4
Interval Match Calender 1
Interval Match with two tables 1
IntervalMatch 18
IntervalMatch on multiple fields with multiple condition in a table 4
INTERVALMATCH YOY 1
Intervals 5
Intervel call 1
into 1
intraday 1
invalid dimension 1
Invalid expression 1
Inventory 3
Inverted Axis 1
invisiblesheet 1
InYearToDate 1
IOS 1
ip address in load 1
ipad 1
ipl 1
IRR 1
Irregular CSV file 1
Is the equation of Y Correct Thanks! 1
IS this QLikview Search me option fully functional to use in real dashboard 1
iseries stored procedures 1
Island calender 1
island table 2
Isnotnull 1
ISNULL 2
IsNull() 5
iso 8601 1
issue 3
iteration 5
Iterative Calculation 1
iterative if 1
iterno 4
jade 1
jagan 4
jagan mohan 2
jaganmohan rao 2
Java 3
javascript 4
JD Edwards 1
jira 2
JIVE 1
JMeter 1
Job 2
johnw 4
join 51
join by wildmatch 1
join duplicates 1
Join Logic 1
JOIN MAPPING 2
join max dates 1
Join or Mapping Performance 2
Join Query 13
Join Scripting 7
Join Table 2
join tables 4
join type in script 1
Joining 3
joins 9
Jontydkpi 1
jscript 1
JSON 8
JSON API 1
json file 1
JSON Load 2
Json web 1
julian 1
julian sql filter 1
Just wanting to share some info 1
justificar texto 1
kalender 2
karl pover 1
keep 4
keep all possible values 1
keep dimension constant 1
keep numbers 2
keep numeric data 1
Key 6
key field 1
key fields 2
key relation 1
keyfield 1
Keys 1
keywords 1
KPI 12
KPI Chart 2
KPI List 1
kpi's 2
kpis 2
label 3
labels 6
labels and font 2
lable 1
lable working day month 1
landing 1
larger than 1
largest 2
Lasrefresh 1
Last 3 years in SET analysis Issue and selections also should include 1
last 30 days 1
Last 7 days 1
last Column 1
last cost 1
last day 1
Last Invoice Sales 1
last known vaule 1
Last month 2
Last value 5
last year 3
lastvalue 1
Lastvalue() 1
lastworkdate 1
Lastyeardata 2
Latency 1
latest 2
latest balance 1
Latest Data 2
latest file 1
launch 3
Layout 9
Layout & Visualizations 854
Layout Listboxes 1
LDAP 1
leading 1
Leading zero 3
leading zeros 1
Leap Year 3
Learning 1
Leasing Licences 1
Leave calendar to count the actual leave. 1
Lebanese pound symbol 1
Lectura XML 1
LEF 1
LEF File 1
left 4
left join 11
Left Join between multiple QVD's 1
left keep 1
left() 1
LeftJoin 4
legend 1
LegentOverlapping 1
LEN 3
lenght 1
Lentidão Carga Qlikview x Nuvem 1
less than 5
let 2
LET SET 1
let statement 1
LET using where clause 1
level 1
libro 1
Licence 4
Licence Allocation 2
licence management 2
License 5
License allocation 2
License Issue 1
License Monitoring 1
license update 1
licensemodel 1
Licensing 1
like 1
likned dashboard 1
limit 3
Limit Date 1
limit selections 1
limit x-axis lables 1
limitations 3
limite 1
limited dimension 1
limited lables 1
Limited Load 1
limiting Dimension values 3
limits 1
line 1
line break in print preview 1
line chart 35
Line Chart Dimension 6
line chart embedded 1
Line Chart limitations 1
Line Chart Missing Data 4
Line Chart requirement 3
Line chart using reference line and below of the chart data should be display. 1
line graph 5
line-chart 2
linear regresion line dotplot 1
linear regression 1
Linear Trend 1
LineChart 6
LineChartExpression 9
lineitem 1
linest 1
linest_b 1
linest_m 1
Link 7
Link Table 4
link tables 1
linkage 1
linking 3
linking fields 2
Links 1
LINKTABLE IN DATAMODEL 1
list 5
list box 17
List Box expression 4
List Box Range Values 4
list of selection 1
lista 1
Lista campos orden 1
Listbox 49
listbox color 1
listbox colour 1
listbox tab 1
Listioffields 1
lists 1
literal value 1
live 2
load 48
load .dat file in Qlik Sense 1
load all files in folder 2
Load Balancing - how to monitor 1
Load Data 55
Load Data distinct 4
load editor 1
load error 2
load excel files 1
load excel files no data 1
load file greater than date 1
load from .txt 1
LOAD if 1
load inline 1
Load Inline error when missing the final bracket "]" 1
Load JSON 1
Load last 3 years Data from Sql Select 1
load last value 1
load multiple qvds in qlikview 1
load numbers 2
Load only certain fields and calculate 1
Load only fields with values 1
Load only ID by Max date in Script 1
Load Sc 1
Load Script 68
LOAD SCRIPT CONSUMPTION TABLE 2
Load Script Error 4
Load Statement 1
load table 1
Load tables based on condition 1
load with fieldnames 1
Load YTD & Sum of all prior YTD Values - to display P&L & Balance Sheet for all company codes 1
loaders 1
loading 6
loading data 6
Loading from DB or File at time of Import 1
Loading of Data 2
loading script 4
Loading xlsb files to Qlikview 2
loading_data 2
loadscript 2
local 1
Locale 1
Localized date format 1
location 1
lock 1
Lock to the qvd 1
Locked selections 2
Log configuration 1
Log Files 8
log issues 1
logging 1
Logging files 1
logic 9
Logic Calculation 2
Logic in script 2
logic test 1
Logics 4
logs 2
longest 1
Lookandextract 1
lookup 14
Lookup Calendar 1
Lookup from other tables 1
Lookup from other tables. 1
lookupmax 1
Loop 33
Loop and Reduce 2
loop data model 1
loop in script 3
loop issue 1
loop with multiple condition 3
Loop with peek or Fieldvalue 2
looping 2
Looping variable script 3
loops 8
Loops and Iterations 5
loops in script 1
Lost connection to server 1
ly 2
LYSales 1
LYTD 1
Mac 1
macOS 1
Macro 64
macro bat 2
Macro export 13
Macro export. 1
Macro issue 1
macro showsheet setproperities 1
Macro System 2
macro table box straight table 1
macro-building 3
macros 23
mailsending 1
mailto 1
makedate 2
Maker 1
Making Selections 1
makro 1
Management 46
Management Setup 1
ManagementConsole 2
mangalsk 1
manual 2
Manual field 1
manual list box 1
many to many mapping 1
map 5
Map chart 1
Mapbox 1
mapped drive 1
Mapping 16
Mapping (One- Many) Data modeling 1
Mapping files 1
Mapping in qlikview 2
mapping load 5
Mapping load with calculated expressions or functions 1
mapping table 4
Mapping() 2
mappingload 1
Maps 6
mapsubstring 3
margin 1
mark 1
Market Basket 1
mashup 1
master calendar 30
master calendar error 2
Master Calendar with Sequence Dates 6
Master calendars 2

QlikView App Dev

Topics with Label: Max()

Max count across a single dimension

What is the fastest way to get a max value in a gr...

Returning a value of the max number in a table

find the percentage completed based on two tables

Mark only highest value under a limit - background...

Aggr()