QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

How to sum up values using If when the value is sp...

by on Latest post on by

2 Replies 200 Views

2 Replies

200 Views

Color formating with date value

by on Latest post on by

2 Replies 284 Views

2 Replies

284 Views

Adding to the colour section of expression

by on Latest post on by

3 Replies 337 Views

3 Replies

337 Views

Sum If date condition

by on Latest post on by

11 Replies 719 Views

11 Replies

719 Views

Pick and Match function Optimized

by on Latest post on by

2 Replies 949 Views

2 Replies

949 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,639
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 15
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 193
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 40
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 2
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 666
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 24
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 1
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 20
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 46
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 48
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 34
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 809
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 45
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
Master calender 1
Mastering QlikView Data Visualization 1
MAT 1
Match 23
Match and Pick 1
Match field value 3
Match Function not working in multiple date selections 1

QlikView App Dev

Topics with Label: IF only

How to sum up values using If when the value is sp...

Color formating with date value

Adding to the colour section of expression

Sum If date condition

Pick and Match function Optimized