Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Aggr and Set analysis for YoY analysis

1 Reply 29 Views

1 Reply

29 Views

Expression total using aggr() and SUM()

by on

9 Replies 138 Views

9 Replies

138 Views

Last years sales - should be simple but not workin...

by on

5 Replies 96 Views

5 Replies

96 Views

Labels

$(field) 1
$field 1
$Info 1
% Year over year( YoY) 1
0 valure 1
445 calendar 1
@PDF_in_Qlikview 1
@qlikview 1
@sunny_talwar 2
abbreviation 1
abort 1
above 3
Above() function 1
Access Point 3
accumulates 1
Actions 5
Active Directory 1
AD 1
add 1
aggr 11
aggr function 1
Aggr or Set Analysis 3
AGGR() 5
aggregate 3
aggregating grouped dimensions 1
aggregation 1
Ajax Accesspoint 1
AJAX and IE 1
Alert wizard 1
alerts 1
Alphanumeric 1
Alt 1
Alternate States 2
Alteryx 1
always one selected value 2
amortization 1
anomalies values 1
API 3
App Design 1
App Development 10
application 1
Applymap() 1
array 1
authorization 1
autonumber() 1
average 3
average formula 1
avg 1
avg() 1
axis 3
Azure Cloud 2
bar chart 8
bar chart expressions 2
barchart 1
based on selection previous years data 1
batch 1
Bell chart Normdist 1
between 1
between two dates 1
big picture 1
blank 1
bnf 1
bookmark 3
bookmarks 2
Box Plot 1
boxplot 1
Bucket 1
bug 6
bug wildcard binary load 1
businesshours 1
Button to select Field 2
buttons 2
calculated column 1
Calculated date 1
Calculated dimension 1
calculated dimensions 7
calculated field 5
calculation 2
calculations 2
calendar 7
Case Study 1
ceiling 1
Chaining 1
change selection 1
Character Set 1
chart 6
chart expressions 1
chart function 1
Chart Object 2
charts 2
Charts Select 2
Checkbox 1
chr(13) 1
chrome 1
class 2
clear all 1
ClearAllTrigger 1
cluster 1
Color 5
Color condition error 1
column 1
columns 1
columns dynamically from excel sheets 1
columns Filter 1
Combination of Budget and Actuals 1
Combine fields 2
Combo Chart 7
Community Help 2
community launch 1
comparison 1
Concat 2
Concatenate x Lef Join 1
condition 1
conditional collor 1
Conditional Date Format 1
conditional display 1
conditional expression 1
conditional sum 1
ConditionalExpressions 2
Conditions 2
configuration 1
connect 1
connection 1
consecutive quarters calculation 1
container 4
Copying data 1
correlation 1
Corrupt 1
Cost 1
Count 6
Count if 1
count of division calculation 1
COUNT UNIQUE OCCURENCE 1
cpu 1
create 1
create a customised field 2
Cross Table 2
Crosstable multiple rows 1
Cumulative summation by date 1
Cumulative summation by dimensions 1
Currencies 1
Current Selection 1
curve 1
Dashboard 3
data 1
data checks 1
data converting 1
data governance 1
Data matching 1
Data Model 5
Data Modelling 3
data refresh 1
data science 1
data type 1
data_loading 2
Date 5
date comparison 2
Date converting 5
date field 1
Date filter 4
date function 1
Date Order 2
Date Range 2
Date ranges 1
date time timestamp 1
DATE VALUE 5
Date Variable 1
dates 6
dates comparison 3
decimals 1
Delete 1
Demension 1
Developer 3
Developer Toolkit 1
Development 9
dimension 9
dimension in pivot 1
dimension set analysis 1
Dimensions 15
dimesao 1
Direct Discovery 1
Directory Service 1
Directory Service Connectors 1
Distinct 2
distribute 1
division 1
Division by Variable 1
Document 1
Document Analyser 1
Document Chain 1
Document chaining In Qlikview 1
doesn't null value 1
Dollar Sign 1
double counting 1
Double Dimension 1
DragDrop 1
duplicate 2
duplicates 1
Dynamic selections 3
dynamic variable 1
dynamically from excel sheets 1
DynamicFilter 1
edit 1
Editing 1
email 1
enddate 2
Error Messages 1
excel 2
Excel data 1
Excel Exports 4
Excel Pivot table 1
excel sheets 1
exchange Rate 1
exclude 1
exclude data 1
Excluded Values 2
export 1
export delimited file 1
export ppt 1
expresion 1
Expression 21
Expression Error 3
Expression value selection in to dimension 1
Expressions 18
expressions straight table 1
Extension Objects 2
Extract 4
fact table 2
fail to load 1
field 2
field as variable 1
Field Event Trigger 1
field not found 1
FieldNumber 1
fields 1
file 2
File Size 1
file size large 1
files 1
Filter 4
Filter condition +Condition Filter - Need help here 1
Filter condition in qlikview 2
Filter only on some data 1
filter selections 1
filtering 2
filters 2
FirstSortedValue 1
Firstworkdate 1
Five9 1
flat table 1
floor 1
folder 1
for next 1
format 1
format num 1
formula 3
formula last year 1
Formules 1
fractile 1
freeze pane 1
function 2
functions 3
Gantt chart 1
Generate an APP 1
Generate dates 1
Generation 1
GetFieldSelections 1
google map 2
Googlemaps 2
grafico 1
grain mismatch 1
Graph 4
Grid chart 1
group by 1
group rank 1
Grouped Bar Chart 1
Guage in straight Pivot tables. 1
having count 1
Help required 1
Hide and show 1
hide excluded 1
hide specific values 1
hierarchy 4
Highlight based two different set of tables and on field value 1
hint would be fine 1
holiday 1
How to Transpose Need some help 1
Hyperlink 3
IE 1
IE Plugin 1
IF & OR 1
IF AND STATEMENT 1
if clause 1
if expression 2
if function 1
if statement 6
image 2
Images 1
in script editor 1
Incremental Load 2
Index 1
inline 1
Inline Load 1
input 3
input box 3
inputfields 2
Integer 1
Integration 1
interface 1
Interpolation 1
interpreting 1
interval 1
Intervals 2
InYearToDate 1
Is the equation of Y Correct Thanks! 1
issue 1
Java 1
join 4
Join Query 1
julian sql filter 1
keep dimension constant 1
KPI 1
labels 1
lastworkdate 1
launch 1
Layout 2
Layout & Visualizations 3
License 1
limite 1
limiting Dimension values 2
line chart 4
linear regression 1
LineChart 1
LineChartExpression 2
linking 1
list box 2
Lista campos orden 1
Listbox 1
live 1
load 1
Load Data 1
Load Data distinct 1
load excel files 1
Load Script 7
Load Script Error 1
Load tables based on condition 1
loading data 3
Log Files 1
Logics 1
lookup 3
Loop 2
loop with multiple condition 1
Looping variable script 1
loops 1
Loops and Iterations 1
Macro 12
Macro export 1
macros 6
mailto 1
Maker 1
makro 1
Manual field 1
map 1
Mapping 2
mapping table 1
Maps 4
master calendar 4
Match 3
max 1
max date 1
Max Function 2
maximum measures 1
measure 1
measures 1
Measures expressions 1
Mekko chart 1
menu 1
merge 1
Merge Rows 1
meta file 1
Migration of the Qlik apps 1
Migration of the Qlik apps. 1
Min 1
Min() 1
Missing Data 1
Missing Fields 1
missing records 1
Mobile 1
month sum 1
moving labels 1
mp4 1
MTD 1
Multi Box 1
Multi dimension chart 4
multiple 3
Multiple between in set analysis 1
Multiple Criteria 1
multiple date 1
Multiple fields 1
multiple filters 1
multiple results 1
multiple values for expressions 1
mysql 1
n-levels 1
Nearest value for 2 columns 1
Negative and Positive Values in Pie chart 1
Negative values 1
nested 1
Networkdays 1
New if Condition 1
new key 1
New Qlik Community Design 2
new table 1
New To Qlik 5
New to Qlik Community 1
New to Qlik Sense 3
New to QlikView 13
NewtoQlikView 3
no measure 1
no of customers 1
no value 1
NoOfColumns 1
NoOfRows 1
Not getting the MAX Month Data of latest year 1
NPrinting 2
NPrinting September 2018 1
null values 2
null values in pivot table 1
NullCount 1
NullInterpret 1
number of days 1
numbers 2
object 1
objects 1
ODAG 1
ODBC 3
OnDemand 1
one dimension 1
only 3
open in server 1
open pdf link 1
openurl 1
ORA-12154 1
ORACLE 1
OSUser 1
OtherSymbol 1
Outlook 1
Overview 1
parameter 1
Pareto 2
path 1
PDF 1
Peek 2
peek() 2
percentage 1
performance 1
PerformanceIssues 1
permisos 1
pick 1
Pick(Match()) 1
pie chart 2
Piechart 1
pivot 7
pivot expressions 1
Pivot Filter 2
pivot table 9
Pivot Tables 3
pivottable 1
pop up 1
Populate Column Data 2
Populate null values 1
possible dates 1
PostgreSQL 1
PowerBI 1
presentation 1
Previous 2
previous value 1
Previous year 1
qlik 2
Qlik App 6
Qlik Chart Functions 2
Qlik Community 15
Qlik Community Team 5
Qlik Connectors 1
qlik Developers 1
Qlik Explorer for Developers 1
Qlik Mashup 1
qlik regardless any selection 1
Qlik Sense 3
Qlik Sense App 1
Qlik Sense Desktop 1
qlik server 1
qlik view 2
Qlikmap 1
qliksense 3
Qlikview 25
QlikView 11.2 2
Qlikview 12 6
QlikView 12.2 2
Qlikview 12.20 2
QlikView 12.30.20000 2
qlikview 9 1
Qlikview advanced 1
QlikView App 21
QlikView App Development 77
Qlikview application development 2
QlikView Applications 17
qlikview chart with 2 dimensions Screen shot pasted 1
qlikview deployment 2
qlikview design 3
QlikView Desktop 6
QlikView Development 8
qlikview expressions 2
QlikView Extensions 1
QlikView Features 3
QlikView November 18 1
Qlikview November 2017 SR7 1
qlikview output 1
Qlikview print settings 1
QlikView Publisher 1
QlikView scripting 9
Qlikview Section Access 1
QlikView Section Access Tab show hide 1
qlikview security 1
QlikView Server 2
QlikView Webview Mode 1
Qlikview12 1
QMC 5
QMC - Auto Qvf file deployment 1
QMC supporting tasks 1
QMS 1
QMSAPI 1
QMSEDX 1
QTR 1
Quarter display 1
Quarter Year 2
quotation 1
QV calendar 1
qvd 3
QVD issue 1
QVD to SQL server. 1
qvw 2
Random 2
range expression 1
rangesum 5
Rank 8
rank function 1
Ranking 2
ratio 1
real-time 1
recargas 1
recno() 1
Recover 1
recovery 1
Recreate Excel Pivot Table In Qlikview 1
reduce data 1
Reference line 1
refresh rate 1
reload 4
Rename Field 1
Repeat Data 1
Repetitive Sorting 1
replace 1
report 1
reports 2
repyament schedule 1
Research 1
resident load 2
REST API 2
RGB 1
Roll Up Sum 1
rounding 2
rowno() 3
Rwunderlich 1
Same records 1
SAP 1
SAP BW Report Data Fetch 1
SAP Report 1
Save Error 1
scale 2
Scatter chart 1
SCD 1
SCENARIO 1
schedule 1
Script 21
Script and Expressions 6
script expressions 1
Script level sorting 3
Scripting 13
Scripting and Expressions 1
scripts 1
scrollbar 1
scrolling 1
Search 1
search and replace 1
search string 1
Section Access 3
Security 2
security rule 1
select 1
select in field 1
selection 1
selection box 1
Selection issue 1
selections 2
Self referencing column 1
semana 1
Semaphore 1
Send to Excel 1
Sequence 1
Sequence using Above() 1
server bookmarks 1
ServerObjectHandlerBatch 1
set an 1
Set Analisys 11
Set Analyse 2
Set Analysis 46
set analysis average 1
Set Analysis filter is not working as Expected 1
Set Analysis syntax 2
Set Analysis Syntax Error 2
set analysis variable 1
Set anaysis 1
Set Date 1
Set Expression 3
set expressions 3
set-analysis 2
set_analysis 1
set_modifiers 1
setAnalysis 2
Sharepoint 4
sharepoint to qlikview connection: 1
Sharepoint_List 1
Sharing 1
show all values 1
show last value 1
Show task execution time within a specified time frame by merging cells of table 1
show. no data 1
single fact table 1
size 1
slicers 1
slider 1
Slowly Changing Dimensions 2
SOAP 1
sort 1
Sort by expression 2
sorting 2
Sorting months 2
Sorting My Objects 1
Sorting of dimensions 1
sorting values 1
SortingIssue 1
SQL 1
SQL Data load 2
sql import 1
sql select 1
SQL Server 1
SSRS 1
stacked bar chart 1
stacked chart 2
standard deviation 2
started_Date 2
STARTRFC 1
Static Max 1
Stock 1
store 3
Store a table in QVD in Server 1
store CSV 1
STORE QVD 1
Stored Procedure 1
Straight Chart Expressions 1
straight table 14
String 5
String to date 1
Strings 1
stringToEscape 1
structure 1
Subfield Function 1
subquery 1
subset 1
substring 4
sum 3
sunny_talwar 5
suppress null 1
Symbols 1
table 4
table box 1
Table chart 1
Table exists 1
table expression 1
table structure 1
Table Viewer 1
table_popingup 1
Table_structure 1
tables 2
tabs 1
Target Table 1
Teradata 1
test 1
text 1
Text Boxes 1
Text colors 1
text object 1
TextObjectActions 1
TextObjectTriggers 1
Time comparison with an existing date-time combined field 1
TimeDifferencebetween2timestamps 2
timeofday 1
Timestamp 2
top 1
top 10 1
Top 5 2
top N 3
Top N % 1
top5 1
Total 6
Total Case 1
total row 1
Total straight table click 1
Totals 1
transfer state 1
Transform and transpose 1
travel 1
tree 1
tree diagram 1
tree view 1
Trend 2
trend line 1
Trending 1
trigger 1
Triggers 5
TriggerWithAlternateState 1
two dimension 1
Two Level SCD 1
two measures 1
txt 1
Unable to Load Max Year data 1
Unable to reload dashboard using QMC 1
unblanced 1
update 1
update qvd 1
upload file with variables columns and transpose 1
URL 3
URL selections 1
User Authorization 1
User defined field 1
user privileges 1
using two different date fields for calculation of months 1
utf16 1
utf8 1
value 2
Value handling in string 1
Value Handling Variable 4
valueloop 1
variable 7
variable input 2
variable inputs as deminsions in set analysis 1
Variable values 1
variable values in if statement 1
Variable values into loop 1
Variables 15
VB 1
vba 2
VBA CSV Browser 1
VBScript 2
verify filter 1
web 1
web files 1
webview 2
week 1
Weekend Date 2
weeks 1
where exists 1
while 1
while loop 1
whole data 1
Wildcards 1
windows checkbox 1
Word 1
working days 1
Working Hours. 1
workinghours 1
wrap 1
wöchentlich 1
X-Y 1
Year to Date 1
Year-Over-Year 1
YOY 1
ytd 2
YTD Listbox month names 1

QlikView App Development

Topics with Label: Aggr or Set Analysis

Aggr and Set analysis for YoY analysis

Expression total using aggr() and SUM()

Last years sales - should be simple but not workin...