New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

SUM question with exclusion

by on Latest post on by

13 Replies 394 Views

13 Replies

394 Views

Set Analysis. Final exclusion operator, with sum A...

by on Latest post on by

2 Replies 176 Views

2 Replies

176 Views

Labels

"colour" "bar chart" 1
"Data Handling" "Nested Ifs" "Multiple Conditions" 1
"gamma distribution" "passwords" 1
"Left Join within condition" 1
"Left keep" 1
% 1
% of Total 1
'comment field' 1
'comment table' 1
'condition' 1
'Filter' 1
'Qlik Sense' 1
'Sense' 'Install' 'Windows 16' 1
* values 1
** 1
- sign 1
-(aggr( formula 1
...................... 1
.json 2
.NET 1
.NET Core 1
.net sdk 1
.qvf file 2
.qvf file error 1
.qvf file not opening 2
.qvs 1
0 values 1
000 1
000 only. 1
100% 1
100% Stacked Bar Chart 2
2 dimensions 1
2 nodes 1
2 variables 1
20% 1
2020 June 1
4 weeks in Pivot table 1
403 1
404 1
404 Error 1
4d 1
4dd 1
6 1
<dimension> 1
@CELAMBARASAN 1
@Jagan 2
@marcus_sommer 1
@mto 2
@pradnyan 1
@qlik sense 6
@rwunderlich 1
@sunny_talwar 12
@sunnytalwar 3
@vegar 1
a new field from already calculated fields LOAD 1
AAI 4
abbreviation 1
ABC analysis 2
above 14
above() 4
Above() function 8
above() in bar chart 1
absolute value 2
accent 1
Access 11
Access Database 3
Access Denied 5
access issue 1
access rights 2
access rule 2
Access to a particular group by using binary load in server 1
accessibility 1
accessing streams 1
AccessToken 1
accordion 1
account 1
account termination 1
accounting 1
accumulate 1
accumulate sum 1
accumulated 2
accumulated sum 5
Accumulation 4
accumulative line in combo chart 1
Acess 1
Acessar um dashboard a partir de uma intranet 1
acsii 1
action 1
action button 3
Actions 4
actions and triggers 1
Actions Bookmarks Dates 1
active caption 1
Active Directory 6
actual currency rate from National Bank 1
Actualizacion 1
Actuals 2
Acumula 1
acumulado 2
acumulados 1
AD 1
add 2
Add AVG 1
add column 1
add data 1
Add fields dynamically to expression 1
add limit 1
add user to app (Qlik Sense Server) 1
add zeros 1
addifset 1
Adding dynamic values 1
addyears 2
ADFS 2
Adjust 1
Adjusting 1
Admin 7
admin termination 1
Administration 3
Advanced Aggr 1
Advanced Analytics Toolbox 3
advanced maps 1
Advanced qlik 1
advanced text object 1
Advanced visualization 1
age 1
Age Bucket 1
age calculation 1
age formula 1
Age Grouping 1
aggr 53
aggr avg sankey 1
Aggr concat with count 1
aggr function 5
Aggr GroupBY Year Help QlikSence 1
Aggr Help GroupBy Year QlikSence 1
aggr if 4
Aggr Only 1
Aggr or Set Analysis 12
Aggr QlikSence Example 1
Aggr QlikSence Help GroupBy Year 1
Aggr Sum 8
AGGR() 64
Aggr. Function 4
aggregate 12
Aggregate and Average 8
aggregate areas 1
aggregate sum 3
aggregated 1
aggregated data 1
aggregated sum in matching fields 2
aggregating data 3
aggregating grouped dimensions 1
aggregating previous months 1
aggregation 18
aggregation function 1
Aggregation in script 1
aggregation with if 1
aggrigation 1
agrupar 1
aider 1
alb 1
alert 3
alerts 1
Alias 2
alignment 2
all 1
all records 1
allocation 1
allocations 1
Alphanumeric Sorting in Qlik Sense 1
Alt 1
Alternate Dimensions 1
Alternate extension 1
alternate state 3
Alternate State count filtered 1
alternate state with If condition 1
Alternate States 17
Alternate states dimension IF alternate states 2
alternative 1
Alternative dimension 2
alternative measure 1
Alternative state 1
alternativedimension 1
always one selected 2
always one selected value 2
Always One Selection 1
Amazon 1
Amazon Redshift 1
amazon S3 2
Amazon Web Service (AWS) 2
amortization 1
an error has ocurred 1
An error occurred 2
Analisis de conjunto 1
Analysis 9
Analysis Services 2
Analytics 3
Analyzer 4
analyzer allocations 1
and 6
and automatically upload excel file 1
AND logic 2
and MEDIAN 1
and operator 1
and or operator 2
AND-mode 1
AND_Operation within column 1
Android 2
angular 4
AngularJS 1
anidar 1
anil babu 2
animated graph 1
annotations 1
Anonymous users 1
another column comparison 1
any tool to convert Qlikview app to Qlik sense 1
AnyChart 2
AnyGantt 2
AnyGantt Extension 2
Apache 1
API 32
API's 2
apiangular 2
APIs 4
app 6
App contents 1
APP Custom Properties 1
App Development 20
APP ID 1
App Integration API 1
app level management 1
app load issue due qlik sense version 1
App Name or QVF Name and QVD Name details 1
app navigation 1
app performance 1
app preload 1
app published date 1
app publishing 1
app security 1
App Size 2
appear 2
append 2
append string depending on lenght 1
Appending a column 1
Appending Data Monthwise from extractor 1
Appending Extracted data for the month 1
appending qvd for the month 1
appid 1
application 6
Application import error 1
applicationmaintenance 1
applications 2
Apply 1
apply multiple changes 1
applymap 10
Applymap() 14
Appointments 1
approval 1
apps 5
appscripts 1
AppyMap 1
April 2019 2
area 1
area layer 3
Area Map 2
areas 1
arquitetura 1
array 4
array type data load data base 1
arrg 2
Arrow Object 1
Articles 1
as 1
As of table 1
As Qlik Help 1
AS400 1
ASCII 1
ASCII to char 1
asignar proyecto 1
asof 1
asset 1
associate table 1
Association 6
association reccomendation 1
associations 4
Associative 1
Associative Insight 3
Atlassian 1
attendance 1
attrition 2
attrition rate 2
audit 1
audit admin 1
authenticate qliksense desktop 1
authentication 10
authentication in qliksense 1
authorization 3
auto calendar 2
auto calendar in semester to date 1
auto generate 1
auto generated Script 1
Auto Refresh 2
auto zoom 1
auto-filtration 1
auto-select 1
autocalendar 5
autofill 1
autogenerate 2
Automated 1
Automated Data Exploration 1
Automated Mail 1
automatic 2
Automatic Field Filling 1
automatically 1
Automation 2
automise 1
AutoML 1
autonumber 3
autonumber() 1
Autozooming in Qlik Sense 1
availability 1
Averag of weekdays 1
average 19
Average Calculation 3
average calculations 3
Average Count 3
Average Count Set Modifier 1
average formula 5
Average growth Rate of two measures 1
average line 1
average measure 1
average of quartile 1
Average reference line 1
Average Time Interval Duration 1
Average Trendline 5
averages 1
avg 11
avg daily 1
Avg Function 2
avg() 1
AvgHeadcount 1
AvoidOverlapping 1
AWS 3
axis 6
Ayuda 1
Azure 4
Azure Cloud 1
azure devops 1
Año 1
Back button 1
background 5
background color 6
background colour 1
background expression 3
Background Image in landing Page 1
backgroundColor 1
backgroundcolorexpressions 1
backup 9
backup and restore 1
Backward Planning 1
balance 1
banco de dados 1
Banding 1
bar 8
Bar & Area Chart 6
bar chart 51
Bar Chart 2 dimensions relative percentage stack 3
bar chart expressions 8
Bar chart sort 1
Bar chart with values 6
Bar charts 32
Bar charts expressions 3
bar graph 6
barchart 16
barchartwithGroupedandStack 1
Bargraph 1
barras 1
barsplus 1
BASE 64 1
baseline 2
basic authentication 1
Basics 2
basket 1
before 1
before() 2
begginer 1
beginner 3
beginner help 1
below 1
below target positive 1
Best Practices 3
between 3
between two dates 1
BI 2
Big Data 4
Big Screen Dashboard auto refresh 1
bigquery 1
binary chart 1
Binary Load 7
binary signal 1
bing 1
bins 1
bla bla bla 1
blank 5
blocks 1
blog 1
bold 2
BOM 1
bookmark 10
Bookmark object 3
Bookmark Trigger 2
Bookmarks 7
Bootstrap 1
borders 2
BOT 2
Bottom 10 values 1
box filter YTD 1
Box Plot 3
brackets 1
branding 1
breadcrumb 1
break 1
Break line 1
Break line chart 1
BreakEven 1
britt 1
browser 1
Brushing 1
BSEG 1
btp 1
bubble 1
Bubble Dimension restrict 1
bubble layer 1
Bucket 1
Bucketing 3
buckets 4
bug 13
Bugs 3
Bugs & Errors 7
Bullet Chart 1
business 1
Business Analyst 4
Business Intelligence 2
business trial 1
but the User dont see anything 1
but user able to access other reports(QMC) 1
button 8
Button Actions 1
button extension 2
button for navigation 3
Button to select Field 4
Button to switch betweeen languages 1
button. 1
ButtonActions 2
buttons 5
by 1
by date 1
by expression 1
by month 1
bytes 1
C sharp 1
CAC 1
Cache 5
Cache objects 1
cache warmer 1
cache_warmer 1
calculate 3
Calculate Count of Unique ID with Grouping in Qliksense 1
Calculate percentage 1
calculate percentage using total in table. 1
calculate total with variables 1
Calculated date 3
Calculated dimension 15
Calculated Dimension Colors 1
calculated dimensions 4
calculated field 16
calculated fields 1
calculating 1
calculating age 1
calculating dates 1
calculating values in script 1
calculation 9
Calculation Condision 2
Calculation Condition 5
calculation of avg by excluding of certain numbers 1
Calculation of Rolling period by 8 weeks to get the sum of appropriate measure 1
Calculation per day 1
calculation timed out error 1
calculations 10
calendar 26
Calendar Control 2
Calendar Extension 2
calendar script 2
Calendar table 4
calendar view 1
calendars 2
Call 1
Call center 1
Cals 1
Campo 1
campos 1
Can I get [Total contract Value] result value below 2 1
Can't open my Qlik Sense Destop 1
cancel request 1
cannot load 1
canonical calendar 2
Canonical Date 4
cantidad 1
capability api 3
capitalize 1
capture 1
capture the last loaded value 1
capture the records that have 2 data loaded with a specific value 1
cardinality 2
care 1
Carga com o arquivo atual 1
Carga Fichero 1
Cargar archvo excel 1
Cascading 1
case insensitive 1
case when 2
categoria 1
categorical 1
Categorize 1
category 5
CEF Error 1
cell 1
cell value 1
cells 1
celula tabela data 1
certain row no 1
certficate 3
certificate 2
certificate security 1
certification 8
challenge 4
change 4
Change color 1
change date 1
change field name 1
Change Headers 1
Change Name Dimension Maps 1
change selection 1
Change YOY 1
changing chart 1
changing colors dynamically 1
changing title colors 1
char 3
character 1
Character Set 1
characters 1
Charges 1
charset Umlaut display Loading skript UTF-8 1
chart 56
Chart bar 5
chart expression 6
chart expressions 17
chart filter 1
chart function 1
chart functions 5
chart interaction 2
chart mesaure script 1
Chart Object 8
chart properties 1
chart selections 1
chart sense color 2
chart with three columns 1
charts 29
Charts Select 4
chatbot 2
CHAVE 1
check 3
Checkbox 1
checked 1
checksum 1
chennai 1
child 1
chr(39) 1
chrome 2
Circular Reference 3
Circular reference error 1
circular_reference 2
Claim Line 1
claims data financial data 1
class 4
class() 2
classification 1
Clean 1
Cleansing 2
clear 1
Clear filter 1
clear selection 1
ClearAllTrigger 1
ClearFields 1
Cli 2
click cell 1
client auth link 1
Client Authentication 1
Client authentication link 1
Climber 2
climber cards 2
Climber Container 1
climber kpi 1
Climber Selection Bar 3
Cloud 8
Cloud Business 5
Cloud Sense 3
Cloud services 1
Cloudera 1
cluster 1
CMD 1
Code 1
code release impact 1
Code Validation 1
coding 1
cohort 1
Collapsible Dimension 1
Color 35
color area layer 1
Color background in pivot table 4
Color blind 2
color by conditions 1
color by dimension 1
color by dimension and by measure 1
Color by dimension value in qliksense 4
Color by dimension value in qlikview 1
color by expression 10
Color by measures value in qliksense 3
color by trend 1
color change 1
Color coding 3
Color Coding Logic for Pivot table 1
Color condition error 2
color condition on text box 1
color dimension 2
color expression 6
color expression for numberintervall 1
Color for measure 1
Color formatting 1
color line chart 1
color line chart by trend 1
Color linked 1
color measure 1
color of labels 1
color schema 1
color text 1
Colorear número en gráfica 1
COLOREAR POR EXPRESIÓN CUARTIL INFERIOR-SUPERIOR 1
coloring 3
coloring of total depending on subtotal 1
coloring pivot table 1
ColorMix 5
colormix1 1
colormix2 3
Colors 9
colour 6
COLOUR BAR GRAPH MEASURE 1
colour by expression 3
colour change 2
colour selection 1
colourblind 1
colours 1
column 15
column dimension 2
column headers as Filter values 1
column headings 1
Column labels 1
column name 1
column order 2
Column Set analysis 1
column table measures 1
Column Total in P&L pivot table 1
column width 1
columns 4
columns change 1
coluna dias atrasados 1
combi diagram 1
combination 1
combine 4
combine dimensions 2
Combine fields 4
Combine of flags 1
Combine rows 1
combined chart 3
combining 1
combining tables 1
combo 2
Combo Chart 27
Combo chart sorting 1
combo charts 3
combochart 2
Combustible 1
comma 1
comma separated 1
Community Corner 1
Community Document 1
Community Help 36
community sheets 1
communtiy 1
Como incluir uma imagem no dash usando uma claúsula de condição 1
Comodo 1
Comparation 2
COMPARATIVE 2
comparative analysis 6
comparative field 1
compare 10
Compare date 2
Compare Dates in between in another column 1
compare dimensions between rows 1
Compare Field with other Field in same dimension 2
compare fields script 1
compare numbers 2
compare range with each other 1
Compare same periods different years 1
compare two columns 2
Compare Values Qlik Sense Help 1
compare_periods 1
CompareValue Compare SameTable Qlik HelpPlease 1
Comparing Dates 2
comparison 8
comparison between months 5
Comparison Type 1
comparison via set expression 1
comparison_period 1
Competitive analysis 1
Compiled Open Source Plugins 1
complex measure 1
complex OMIT 1
complex pivot 1
complex Reduction 1
composite key 3
composite keys 1
compression 2
Concat 8
Concat on two generic fields 1
Concat value 2
Concat() 2
concatenante 1
concatenar columnas osticket concat columns NA 1
concatenat 1
concatenate 14
Concatenate 2 Fact tables 1
Concatenate based on list 1
concatenate expressions 2
Concatenate more rows to one row 1
Concatenate x Lef Join 1
concatenated 1
Concatenating data 4
Concatenating data monthwise 1
concatenation 4
Concescutive 1
condiciones 1
condition 5
conditional 8
conditional collor 3
conditional color 1
conditional colors 2
Conditional Column 6
conditional count 2
Conditional Date Format 2
conditional display 3
Conditional Display of Measures 4
conditional expression 2
Conditional Expressions 8
conditional filter 1
Conditional format 3
Conditional formatting 9
Conditional formatting in Qliksense 1
conditional group 1
Conditional images 2
conditional load 1
conditional split 1
conditional statement 1
conditional sum 2
conditional sum with variables 3
ConditionalExpressions 13
Conditions 7
Conditions matching 2
conector web 1
Configuration 5
connect 1
Connecting to DerbyDB 1
Connecting to QlikSense via .NET SDK 2
connection 13
connection error 2
connection lost 4
Connection Microsoft Access 365 Database 1
connection string 3
Connection to Qlik Sense Engine Failed 1
connections 9
Connectivity 1
Connector 8
Connector reply error 2
Connectors 6
consolidate 2
Constant 1
Consumer Node 1
Contador de datos sin repetición 1
container 6
containers 1
contar 1
contcat 1
content 1
content admin 1
content library 3
context 1
context menu 1
continuous 2
continuous data 1
continuous scale 2
continuous Service 1
Continuous Value (Data) 1
contraseña 1
Control Chart 1
Conversion 4
conversion table 1
convert 6
convert monthly to daily 1
convert problem 1
convert qlikview to qlik sense 1
convert string to number 1
convert tiff files 1
converter 2
converttolocaltime 2
Coomand to execute QS 1
coordinates 2
copy 2
Copy Value 1
Copying data 1
cores 1
Correlation 1
Correlations 1
corrupted data 1
cors 2
CORS Vulnerability 1
Count 86
count according to rank 1
Count Aggr If 1
Count based on another counted field 2
Count Blank 1
Count clarification 1
count count it 1
count distinct 3
Count formula 1
Count if 10
Count if condition 7
count if date filter 1
count if null 1
COUNT if two conditions 4
count of 4 consecutive date with respect to id 1
count of count 1
Count of distinct with set analysis 1
count of rows 1
COUNT Parameters 4
Count Rank 1
Count Rank QlikSence Help 1
Count record by data 1
count rows 1
count session active 1
Count sheets 1
Count top 10 from table 1
COUNT UNIQUE OCCURENCE 4
count with condition 1
Count with If condition 3
count words 2
count() 5
count(distinct ) 1
counter 3
Counter Field 1
Countif 3
counting 3
counting words 1
Countries 2
Country based on city 1
counts 2
COVID-19 1
cpu 1
Crash 2
create 1
CREATE "CALENDAR" 1
Create column based on measure 1
Create connection Script editor 1
create drill down with Master Items on Dimension 1
create flag load editor 1
create flags (dynamically) depending on year 1
Create in Scriptarea the key figures (as one expression) 1
create new app 2
create new column 1
create new field 2
Create one table from 3 columns 1
create separate block each in block chart. 1
Create Tables Automatically 1
creating a table from one table 1
creating columns 1
creating dates 1
creating new field 1
Creating Relations between two tables in a Load Script Editor 1
Creating start and end time from changing dimension 1
creation of backward data field 1
Credentials 1
criteria 2
Cross App data selection 1
cross hub access 1
Cross Table 11
cross table in qlik sense 1
Crosstab 1
crosstable 15
Crosstable multiple rows 1
Crosstable or another way of tabletransforming 1
CrossTable with multiple columns 1
Crosstable(transforming of table) 2
CSR 1
css 8
CSV 12
CSV file upload to QLIK Sense Cloud 2
CSV to QVD without Qlik 1
cte 1
Cube 2
Cummulative 5
cummulative sum 3
Cumul Value while Selection 1
Cumul Value within Pivot plus Dimension (horizontal) 1
cumulative 9
cumulative % 2
Cumulative calculation using range sum function 2
cumulative chart 1
cumulative count 2
Cumulative count with 2 dimensions in a bar chart 1
Cumulative counts for multiple dimensions 1
Cumulative Returns 1
cumulative sum 1
cumulative sum in chart 2
Cumulative sum in cross table 1
Cumulative sum in straight table 1
Cumulative summation by date 4
Cumulative summation by dimensions 4
Cumulative total 3
cumulativesum in Qliksense 1
cumulul value in depence on moths 1
Currency Rate 1
current cell value 2
current month 3
Current Selection 1
Current Year 3
Current year vs last year 1
curva abc 1
custom 6
custom chart 1
Custom Color 3
Custom Component 3
custom date filter 1
Custom Extension 1
custom field 3
custom labels 1
custom limitation 1
custom markers 1
custom measure visibility 1
custom measures 2
Custom Message 1
custom objects 1
custom pie chart 1
Custom Production Hours 1
custom properties 4
custom property 1
custom region 1
custom reports 1
custom sort 3
custom sorting 2
custom theme 3
Custom Themes 3
custom tooltips 1
Custom UI 1
custom variable 1
custom week 1
Custom year 1
CustomConnect 1
customer 1
customers 1
Customers bought 1
Customization 7
Customize 4
Customize color 1
customized calendar 2
Customized Filters 1
customized log files 1
customized tooltip 1
CustomProperties 1
customreport 1
cut 1
CVS 1
cyclic dimension 1
código 1
d3 1
d3.JS 1
daniel coullet 1
dash 1
Dashboard 17
dashboard bundle 7
Dashboard Extension Bundle 5
dashboard issues 4
dashboards 2
data 26
data affected in one filter only. 1
data aggregation 1
Data Analytics 4
Data Architect 3
Data Architecture certification 1
Data connection 8
data connections 7
data connectivity issue 1
data connectors 1
Data Consistency 2
data cube 1
Data Dictionary 1
Data display for Previous year along with previous year records 1
Data Encryption 1
data exhaustivity 1
Data Export 1
data extraction 1
Data Extraction Issue 1
data filtering 1
data format 2
Data From folder 2
data island 1
data labels 1
Data limitation 1
data load 24
Data load editor 35
Data Load Error 3
data load fail 1
Data load issue 1
data load problem 1
data load script 2
data loading 3
Data Loading from Source 3
data manager 12
Data Manipulation 2
data masking 1
DATA missing error 1
data mode 1
Data Model 14
Data model Issue 2
Data model viewer 2
data modeling 1
data modell 1
Data Modelling 11
Data Preparation 5
Data Presentation 1
data range 1
DATA REDUCTION 5
data refresh 1
data source 2
data table 1
data transformation 2
data type 1
data types 2
data upload 1
data validation 2
data visualization 2
data wrong showing using script editor 1
database 8
database dynamically 1
Database Error 2
Database Query 2
Dataconnections 2
datafiles 1
Dataflow 1
dataload 2
Datamanager 2
Datamodel 3
datamodel logic 2
datamodeling 1
datamodelling 1
datapoint 1
datapoint and datalabels 1
Datapoints 1
datarestriction 1
DataSet 3
datatype 1
DataWarehousing 2
Date 5
Date & Time 6
Date Bucket 2
date conversion 2
date convert 1
Date converting 2
date data 1
date data exhaustivity 1
date difference 2
date dimension 1
Date Expression 13
date field 2
Date filter 14
date format 14
date format not respected 1
Date format wrong. 1
date formatting 4
date function 1
Date Functions 13
date groups 1
Date Help QlikSence TimeInterval 1
date picker 16
Date Picker Extension 4
Date Picker Extension not recognize Field 1
Date Picker. 2
Date Range 23
date range picker 2
Date range picker extension 4
date range selector 1
Date ranges 3
Date set 3
date settings 1
Date time 2
date time timestamp 2
DATE VALUE 11
Date Variable 3
date(0) 1
DATE_IN and DATE_OUT in Master Calender 1
Datefield not recognized as Date 1
DateFilter 2
DateFormat 3
DateFormatting 1
dateperiod 1
datepicker 1
daterange 1
Daterangepicker 1
dates 21
dates between 7
dates comparison 1
Dates differenece in days 1
Dates Help 5
Dates Transformation with different formats to single format 1
datetime stamp transformation 1
DateTimeformat 2
datevariable 1
Datum 3
day 3
day count 1
day(today()) 1
DayName 1
dayofweek 1
days 2
db 1
DB2 2
DCom server process 1
de 1
de couple 1
deadline 1
Deadlines 1
Deall 2
debug mode 1
debugging 1
decimal 1
decimals 3
default 4
default filter 2
default search mode 1
default selection 4
Default Settings 1
default sheet 1
default value 2
default values 2
default view 2
defaultbookmark 1
define dimensions 1
define measure 1
defining geography 1
definition 1
DEL files in Qliksense 1
Delete 3
delete account 1
delete row 1
deleted 1
Deleting QVDs 1
Deleting values 1
delimiter 3
Delimiter Split and matching 1
Delimiters 1
deltaload 2
demension limit 1
demo 2
demo trial 1
demos 2
demos for both qlikview and qlik sense 1
Denominator 1
density plot 1
Dependencies 1
Dependency Explorer 1
deploy apps via api 1
Deployment 1
depreciation 1
derive 1
Derived 1
derrive 1
descending 1
description 1
descriptive 1
design 8
Designer 3
Desktop 10
desktop authentication offline corporate internet filtered blocked 1
desktop client 4
Desktop Download 1
desvest 1
detach object 1
Detailed Drill Down 1
Details 3
Dev Hub 5
Developer 10
Developer license 1
developers 13
Development 10
devhub 1
diagram 6
Diagramm 1
Dialog 1
Diarias 1
difference between View and Sense 1
different 2
Different dates 1
differential load 1
Dimensiom 2
dimension 38
Dimension as expression 7
Dimension axes 1
dimension counting 1
dimension expression 1
dimension Filter 1
Dimension grouping based on another dimension 2
dimension ignore filters 1
dimension label 3
Dimension labels 6
dimension level 1
dimension limit 3
dimension limits 2
dimension limmits 1
Dimension of stacked & grouped bar chart 2
dimensional calculation 1
Dimensional DB 1
Dimensiones 9
DimensionLimit 1
Dimensions 46
Dimensions as Measures 1
Dimensions grouping 1
dimensons 1
Dimensão 1
Dimensões de uma imagem para não ficar distorcida no Qlik 1
Dimesnion % Calculation 1
Direct Discovery 1
Direct Query 2
directory 1
DirList 1
disable chart interaction 1
disable selection 1
disable standard mode 1
disaggregate 1
discrete points 1
discrete values at all levels 1
Disctinct 2
discussion forum 1
display 5
display if blank 1
Display label 1
Display Table 1
display tiff files 1
Display website dynamically 1
dissapear 1
distance 1
Distinct 18
distinct count 1
distinct sum 1
Distinct values 4
distribute volumes 1
distribution 2
distribution curve 1
distribution plot 6
divide 4
division 3
Division by Variable 1
DNS 1
do 1
do while 3
Do While Loop 1
Do While loops 1
Doc 1
DocAnalyzer 1
Document Analyser 2
Document analyzer 2
document analyzer connection error 1
Document Chain 1
document chaining 1
Document Information 1
Documentation 1
Dollar expansion 4
Dollar Sign 3
dollar sign expansion 1
Dollar sign expansion with variable with & operator 1
Dollarexpression 1
domain name 3
Dont join multiple tables 1
dont work visualization 1
donut chart 2
dosave 1
dot 1
dotnet 1
dots 1
double counting 1
Double Dimension 1
double match 1
down 1
Download 6
drill down 9
drill down charts 4
drill down dimension 1
drill down master 2
Drill Through 2
Drill-Down 14
Drill-down report 1
Drilldown 6
drilldowndimension 1
drop down 2
drop down select 2
drop field from table 1
Drop fields 1
drop table 1
drop-down 1
drop-down list 1
dropbox 1
dropdown list 1
dropdowns 1
dual 7
dual function 4
Dual Set Expressions 2
Dual Use 1
duplicate 2
duplicate column names 1
Duplicate data 3
duplicate fields 2
duplicate records 1
Duplicate Rows 6
Duplicate SAMAccountName Network login account 1
duplicate values 2
Duplicate values in pivot dimension 1
DuplicateID 2
duplicates 3
duration 1
Duties 1
dynamic 15
Dynamic Assignment 2
Dynamic Charts 1
dynamic date expression 1
dynamic dimension as variable 1
dynamic field name 1
dynamic join 1
Dynamic KPI 1
dynamic label 2
dynamic measures 1
dynamic path 1
dynamic report 1
dynamic select 1
Dynamic selections 2
dynamic title 1
dynamic update 1
dynamic URL 1
dynamic variable 2
Dynamics 365 1
each 1
ebiexperts 1
EC2 1
ecuation 1
edit 1
edit email 1
edit variable 1
Editing an app 1
editor 2
efficiency 1
else 1
Else Max Date 1
email 5
email alert 5
Email Server 1
Embed 3
Embed button to web page 1
Embed Sheet 4
Embedded 2
embedding 4
empleados 1
employee status 1
empty data 2
empty values 1
enable 1
enable conditionals 1
enable-non-published-sharing 1
Encode 1
Encounters 1
encryption 2
end of file 1
end time 1
enddate 1
Engine 5
engine api 3
Engine is not alive 1
EngineAPI 1
Enhancements 1
Enigma 2
enigma.js 3
enterprise 6
enterprise version 2
Entwicklungsumgebung (wo am besten entwickelt werden muss) 1
equal 1
ErikWetterberg 1
Error 25
error 1603 1
error 400 1
Error 500 1
error log 1
Error Message 1
Error Messages 3
Error on the hub area 1
Error ORA-01456 Qlik Sense 1
ErrorCode: 4294967192 1
Errorhandling 1
errors 1
es6 1
Español 2
Esri 1
estado 1
estados alterno 1
ETL 4
Event 2
Events 4
evolution 1
exact 1
exact match 1
exact string position 1
exam 1
example 1
Example AAI QVF FIles 3
excel 23
Excel data 19
Excel data sets to Qlik 1
excel date format 1
excel export 1
Excel export wrong data 1
Excel Exports 5
excel file 3
Excel import hard disk local file 2
Excel load to Qlikview 1
Excel pivot data into qlikview 1
Excel Pivot table 3
excel sheets 1
Excel via ODBC 4
excel worksheets 2
exclude 6
exclude data 4
exclude data in column 1
Exclude dimension selection in filter pane 1
exclude legend 1
exclude value 1
exclude values 3
exclude values in column 1
Excluded Values 2
excluding 1
exclue 1
exclusion 2
execute 1
Execute Command 1
Execute Command in Script 1
exist 1
exists 4
Expand 1
expand only left rows 1
Expandissue 1
expansion 2
Export 13
Export as unicode txt format 1
Export ContextMenu 1
EXPORT CSV 2
export data 6
Export data to google spread sheet from CSV file in qlik sense 1
Export Script 1
export sheet 1
export to CSV variable automatically export 1
export to excel 5
export to image 1
export to pdf 2
Exportação de dashboards para PDFs 1
Exporting data 6
expresion 1
expresiones 1
expresión 1
Expression 2
Expression builder 13
expression by color 2
expression editor 4
Expression Error 16
Expression Total 2
Expression value selection in to dimension 1
Expressions 35
expressions straight table 2
extended sheet 1
extending rows in Qliksense 1
Extension 48
extension - IE issue 1
Extension Development 3
Extension Object 1
Extension Objects 11
Extensions 17
extensión 1
External 2
external data 1
extra data point 1
Extract 6
Extract Date from String 1
Fact tables 3
Fact Type 1
facts 1
fail opening hub message first access to sense 1
fail to install the latest version of sense on entreprise PC may be because of entreprise network security policy which inhibits some ports 1
Failed To Invite new members 1
Falha ao abrir hub selecionado 1
family 1
feature 3
Feb 2019 2
Feb 2020 1
feb-2020 1
February 2019 3
February 2020 1
Fecha 2
Fechas 1
Feld duplizieren 1
field 9
field addition 1
field as variable 1
Field Load 6
Field name 2
field not found 2
field not found error 2
field over field 1
Field renaming 1
Field Type 1
Field value 5
fieldIndex 1
fieldname 1
FieldNumber 1
fields 7
fieldvalue 3
figures 1
file 5
file comparison 1
File Detection Trigger 1
File Explorer 1
File name 2
File not found error 1
File Parameter 1
file path 1
files 3
filesize 1
FileSizeMultiplier 1
filesystem 1
Filetime 1
fill out the tows 1
Filling Fields 1
filling missing date 1
Filter 116
filter actualdate date currentDate setCurrentDate 1
filter by 1
Filter by Data Types 1
FILTER BY DATE 1
Filter condition +Condition Filter - Need help here 4
Filter confirmation 1
Filter DataSource 3
Filter Date 5
Filter Dates 4
filter dependency 1
Filter dimension measure 4
filter if 1
Filter in data loading 1
filter logic 1
filter measure 1
filter not working 2
Filter Null Values 2
filter on legend 1
Filter only on some data 1
filter pane 41
Filter pane with color 1
filter panel 7
Filter Panes 2
Filter performance 1
filter pivot 3
filter selections 4
filter value 3
Filter Visualization 5
filtered 1
filtering 8
filtering a bar chart 1
filtering date 2
filtering NULL values 1
filterpane 4
filters 20
Filterselektion ignorieren 1
filtro 1
FILTRO FECHA SIN VALORES QLIKSENSE 1
filtro na horizontal 1
Filtros 7
Finacial Year 2
Financial functions 1
Financial model 1
financial year 2
Find 2
find and replace 1
Find distinct row values from a number of columns and display the distinct row values as columns. 1
find replace 1
Find the sql or script for the QVD 1
Firebase analytics integration 1
Firewall 1
First Date 1
First value 3
FirstSortedValue 23
FirstSortedValue() 4
FirstValue LastValue 1
Fiscal Calendar 1
Fiscal Quaters 1
fiscal year 6
Fiscal Year Calculations 2
fitness 1
Fitting 1
fix 1
Fixar 1
fixed 1
FIXED DIVISION 1
fixed value 1
fixed variables 1
flag 6
flag count 1
flagging 1
flags 2
Floating 1
floor 1
Floor Map 1
floor plan 1
Flow 1
Focus 1
folder 4
folder connection 1
Folders 1
font 2
font color 1
font color script 1
font size 4
font-family 4
fonts 4
for 4
for each Next 1
for loop 10
For loop file store 1
for next 3
forEach 1
Forecast 9
forecast data 1
Forecasts based on 12 months data 1
Forecasts based on last year's figures for the next coming 3 months 1
Foreign Key 1
format 19
format applied on data cell 1
format date 3
format num 1
format numbers 1
format pattern 1
Format Specification Item 2
format string 1
Formating 7
formato 1
formats 1
formatting 9
formatting date 2
formatting dates 1
formatting issue 1
Formatting Rules 2
formula 13
formula filter 2
Formula visible 1
Formular sum 1
Formules 2
FQDN 1
fractile 1
frame 1
framework 1
frecuency 1
Freelancer 2
freeze pane 1
from 1
From Folder 1
front end 2
Front End Help 1
front-end 4
FTP 1
FTP SFTP Connector 3
Fuel 1
full 3
full reload 1
Full row duplicates 1
full screen 2
fullscreen 2
funcionalidades 1
Función 1
function 11
function list 1
functions 11
functions to a drop down list 1
funnel 3
funnel chart 1
fusion chart 1
future cash flows 1
Future values 1
fuzzy 2
Fuzzy search 1
FY 1
g3 Broker API 1
Gannt Chart 1
gantt 3
Gantt chart 6
gauge 3
gauge chart 4
Gauge chart (street light) 1
Gauge chart Limits 1
Gauge Chart reference line 1
gauges 1
gb 1
generate 1
generate date time 1
generate missing data 2
generate values within datafield 1
Generating Months 1
Generation 1
generic 1
Generic calendar 1
generic load 1
Geo 2
geo analytics 1
geo data 1
Geo location 2
Geo Maps 3
GeoAggrGeometry 1
Geoanalytic 1
GeoAnalytics 9
geoanalytics Qlik sense 1
geocodes 1
geodata 1
Geodata layer 1
geodatabases 1
geographic polygons 3
geolocation 1
geomakepoint 1
GeoMapping 2
geomaps 2
GeoPoint 1
GeoQlik 2
GeoTag 1
GeoTagging 1
get 1
Get Cells from all apps 1
get data from table 1
Get rid of Duplicates 1
GetCurrentSelections() 4
getfieldselection 1
GetFieldSelections 6
GetObjectDimension() 1
GetObjectField() 1
GetobjectMeasure() 1
GetSelectedCount 4
GetSelectedCount() 1
Getting Started 2
Getting Started Webinar 7
Getting the total for 1st and 2nd filter values 1
gigabytes 1
GIS 1
global filter 1
Global Grouping 1
Global Variables 1
GM% filter 1
Gmail 1
Google 2
google analytics 4
Google cloud platform 1
Google Drive 1
google drive connector 3
Google Drive Spreadsheets Connector 1
google forms 1
google map 1
Google Sheet 1
google sheets 1
google spreadsheets 1
google-api 1
Googleapis 1
Googlemaps 1
Governance 2
governance dashboard 1
gps 1
GPS co-ordinates 1
gradient 2
grafico 5
grafico de barras 4
grafico de torta 1
grand total 2
granularity 2
Graph 23
graphics 1
Graphs 1
greater 1
greater than 4
greater than equal to 1
greater than in measure 2
greatest 1
greybar 1
grid 3
Grid chart 1
grid height 1
gridlines 1
group 9
group bar chart 1
group by 18
Group by in Load 8
GROUP BY ISSUE 9
Group data 2
group dimensions 2
group nodes 1
Group_Discussions 1
groupby 1
Grouped Bar Chart 3
Grouped data 3
grouping 5
Grouping line chart 1
groupings 1
Groups 1
growth 1
growth rate 5
gráfico 3
Gráfico de Barras 1
gráfico de linha 2
guage 1
Guage in Trellis Container 1
GUI 1
guide 2
Gysbert_Wassenaar 2
half hour 1
hardcode expression qliksense KPI 1
hardcoded value KPI expression qliksense 1
Hardware 1
having 1
headache 1
Headcount 2
header 4
header authentication 3
Header collumn Pivot 1
Headings 1
health 1
Healthcare 1
heat map 3
Heatmap 3
heatmap chart 1
Heatmap chart - visualization bundle 2
heirarchy 1
help 20
Help ! 1
Help Compare Table SetAnalysis Field 1
Help Date Max IF Qlik Sence 1
Help me 6
Help me Set Expressions 3
help needed 3
Help on Selection appear navigation 2
Help on Selection tool 1
Help QlikSence GgroupByMonth Month SetAnalysis 1
Help QLikSence SetAnalysis 1
Help required 6
Help Text 1
HelpPlease Rank SetAnalysis Aggr 1
Hen 1
Henric_Cronström 3
HEX codes 1
hic 1
hide 7
Hide 0 values in combo chart Qliksense 1
Hide and show 2
Hide and show object 1
hide column 5
hide columns 2
hide date 1
hide excluded 1
Hide filter Pane 1
hide legend 1
hide nulls 1
hide row 1
HideExpression 2
hiding 1
hiding data 1
hierarchy 11
Hierarchy Dimension 2
Hierarchy Level Filter 1
hierarchyID 1
High cpu 1
Highest 1
highest sales 1
Highest-1 Quarter and year always selected in filter 1
highlight 4
highlight bar 1
Highlight misorder based on Date 1
Highlighting map area in QS 1
highlights 1
Histogram 6
historical 2
historical data table 1
history 2
Hive 1
hoja 1
horizontal dimension 1
horizontal table 1
Horizontal totals 1
horizontal variance analysis 1
Hour 6
hour by hour 3
hover 4
How To 1
How to access and use the current selected value of the filter in chart expression 1
How to add required color to expression when using multi dimensions in Qliksense Bar chart 1
How to adjust area plot in Bar chart in Qliksense 1
how to apply function on script editor 1
how to calculate the percentage 1
How to Connect ODBC Connection in Qliksense give me an example 1
How to Convert Raw Values into Column 1
How to display values of data points in a combo chart in Qliksense 1
How to export SHAREPOINT OFFICE 365 list data into Qliksense without using Office 365 Connector. 1
How to fill empty cells of 2nd dimension with 1st dimension value in pivot table or in Table in Qlik 1
How to Generate QVD file in Qliksense my Source File is MS-Access Database-SOP.mdb file 1
How to hide line chart when value is zero in combo chart 1
how to load data using script editor 1
how to show last week dates in linechart 1
How to show two dimensions line chart in Qlik Sense 1
How to sort Measures Dynamically in Qliksense Bar Chart 1
How to sort month in an order when displaying last 12 months of data in Qliksense Bar Chart 1
How to split Dimension Label in to two lines in Qliksense 1
HR Talent Management QlikSense 1
HTM 4
HTML 1
html page 1
HTTP 1
hub 8
Hub error 4
hub issues 1
Hub Slowness 1
Hub Streams 1
Hyperlink 3
i can't find the hub 1
I want results as pictures. Please help me. 1
ian_wilson 2
IBAN 1
icons 1
ID 2
id order 1
Ideas 3
Identifiers 2
Identify the data for Multiple databases 1
Identify the data for multiple databases. 1
Identity 1
idiomas 1
IE 2
IE11 3
if 34
IF & OR 15
IF AND STATEMENT 19
if clause 4
if condition 7
if condition with multiple values in Qlik sense 1
If else 5
If Else Expression 3
if expression 5
if function 3
IF only 1
If Previous Month or Before 1
If stament 10
if statement 20
If statement Date range Add Months LasRefresh 1
If statement exclusion 1
if statement in load script 1
if statements 2
If then and else 2
if&setanalysis 1
if() 7
if-statement 1
If...ElseIf 1
If...ElseIf cause 1
IF...THEN 2
ifelse 1
iframe 10
iframe integration. 2
iframes 1
ifttt 1
ignore current selection 3
Ignore dimension 1
Ignore dimensions 1
ignore filter 2
Ignore level in Alternate State filter 1
ignore month 1
Ignore selected field 1
ignore selection 1
Ignore Selection Filter DAY 1
ignore selections 1
ignore the expression via set expression 1
ignoring selection 2
IIS 1
iis server 3
image 2
Image load map 1
Imagem de produtos 1
Imagem em report 1
Images 8
Images in Expression level 1
images of employees on qlik sense dashboard 1
img 1
imgae 1
Implicit set analysis 1
Import 9
Import data R 1
Import Pivot table 2
Improve acces to final user in the acces point 1
improvement 1
In Data load Editor 1
inactive caption 1
Include 5
Include Nulls 2
Incomplete visualization 2
incorrect sum 1
Increase space of Month Names on X axis. 1
Increment 2
increment loading 1
incremental 1
Incremental Load 26
Incremental Load on Date condition 2
Incremental load using SQL Select 5
incremental load without date 1
IncrementalLoad 1
independant selection 1
independently filter 1
indicators 1
Indirect Selections 1
Indirect Set Analysis 3
Individual Totals 1
inferior or egal 1
info bubble 1
information density and subset ratio option 1
Iniciar projeto qlik com alguns campos de filtro marcados com um valor default 1
initialize 1
initializing add data 1
inline 2
Inline Load 4
inner join 2
input box 4
input box objects 1
Input Parameter 1
Input variable 4
INPUTFIELD IN QLIK SENSE 1
Insert 1
Insights 3
Insights Advisor 1
install 3
Installation 13
Installation Error 2
installation guide 1
instersection 1
Insurance 1
Integer 1
Integrate Qliksense & Python 1
Integrate Qliksense into oracle CRM Report 1
Integration 8
Integration with QlikSense 2
Interactions 1
interactive 1
interface 1
Internal Engine error 1
Internal Error 1
internal files 1
Internal Server Error 1
InternationalApparelData.xlsx 1
Internet 1
Internet Explorer 2
interpreting 1
interquartile range 1
intersection 4
interval 7
Interval Dates 1
Interval Match 1
Interval Match with two tables 2
Interval with Inter-record function 1
IntervalMatch 8
Intervals 2
Intranet 1
invalid 1
Invalid field name 1
Invalid Geometries 1
invalid hypercube 1
Invalid load model 1
Invalid Parameter 1
Inventarios 1
invite the user 1
invoice 1
invoice frequentie 1
IOS 1
IoT 1
ipad 1
ipaddress 1
iphone 1
is there any Alternate way for set analysis in load script 1
IsAlive 1
iseries 1
Island calender 1
island table 1
IsNull() 6
issue 2
issue with hierarchy 1
issues 2
It won´t access to hub 1
item data 1
iteration 1
iterno 1
jaganmohan rao 3
jagm 1
jagmohan 4
Java 1
javascript 8
jcdatasax 1
jira 3
Jitter 1
Job 1
join 33
Join By Record Position 1
JOIN MAPPING 4
Join Query 9
join qvd 2
Join Table 2
join tables 1
join to master calender or create the master calender 1
Joining 2
joins 9
jointure 1
JordyWegman 1
JPG 1
jquery 1
JSON 17
JSONB 1
June 2019 4
June 2019. App Overview 1
Jupiter Note book visualizations 1
Just for info 1
Kareo 1
Kareo Analytics 2
kashyap 1
kb 1
KDA 1
keep 1
keep alive 1
Keep first 5 1
Keep Source Format 1
Key 4
Key Driver Analysis 1
keyboard 1
keyfield 1
Keys 3
Khanashique 1
kilobytes 1
KLM 1
kml 4
kml file 3
KPI 59
KPI Chart 14
kpi font color 1
KPI issue 3
KPI percentage 1
KPI with if conditions 1
kpi's 4
Krunch BOT 1
Kubernetes 2
kush 2
label 13
label colors 1
label expression 5
label in bar chart 2
labels 13
labels and font 2
lag() 1
Language of Qlik Sense Data loader 1
languages 2
laptop 1
Large App 1
large number 1
last 1
last 3 months 2
last 3 years 1
last 30 days 1
last 5 1
Last date 1
Last month 5
last reload 1
Last twelve months 1
last updated 1
Last value 3
last year 3
last30days 1
lastvalue 1
Lastyeardata 1
latest 2
Latest Data 6
Latest reporting months 1
Latest values 1
latitude 4
Launch email 1
Layer 1
Layer 1 1
Layers 2
Layout & Visualizations 1
LDAP 2
leading zeros 1
LEF 2
left 3
left join 6
LeftJoin 3
legacy mode 1
legend 5
legend cut off 1
Legend incorrect 1
legend interaction 2
legends 3
LEN 2
less than 1
let 5
LET ELSEIF Variable Script 1
Let IF ElseIF 1
LET SET 2
LET using where clause 1
level 1
lexem 1
LIB CONNECT 1
lib path 1
Licence 5
Licence Allocation 1
licence management 2
licence monitor 1
licences 2
License 12
License allocation 5
License and Operations monitors 2
License monitor app 4
License Monitoring 3
license update 2
lifecycle management 1
light 1
liike 1
like 1
limit 4
Limit Columns 1
Limit Date 2
limit monthly sum 1
limitation 5
limitations 2
limiting data on load 1
limits 1
line 4
line break in KPI field 1
line chart 50
Line Chart Dimension 1
Line Chart limitations 2
Line Chart Missing Data 1
Line Chart requirement 4
Line chart start point 1
line feed 1
line graph 8
Line Graph and Table 1
Line graphs Dates to expand to Months and Days 1
Line in qlik sense 1
line offset 1
Line Wrap Text 1
linear regression chart 1
Linear Trend 2
LineChart 7
LineChartExpression 3
linegraph 4
Lines 1
linest b 1
linest m 1
linest_b 1
linest_m 2
LinEst_R2 1
linestring 2
linha 1
linhas 1
Link 10
Link Calendar 1
link sheet 1
Link Table 7
link tables 3
linking fields 1
Linking measures 1
linux kubernettes 1
list 2
list box 1
Listbox 2
live data sheet 2
lmao 1
LMS 1
LMTD 1
load 23
load balanced 1
Load Balancer 1
Load Balancing 3
load by variable name from data 1
load calcuation 1
Load Data 29
Load Data distinct 1
load editor 6
load file 1
load multiple excel files 1
Load Multiple QVDs in QLiksense 1
load QVD in loop 2
Load Script 55
LOAD SCRIPT CONSUMPTION TABLE 1
Load Script Error 4
Load Statement 2
Load tables 1
Load tables based on condition 2
Load tables field name original rename 1
load tiff files 1
load where <> 1
loading 3
loading csv files 1
loading data 6
Loading Data from Pivot table 1
loading from excel 2
loading issue 1
Loading of Data 3
loading screen 1
loading_data 1
loadscript 2
local 2
local database 1
localhost 1
location 5
location issue 1
Location lookup 2
Locations GeoQlik 1
log 4
log file 1
Log Files 8
log in 1
logged off 1
logging 1
logging file 1
Logging files 3
logic 3
Logic Calculation 1
Logic Function 1
logical operators 1
Logics 3
Login 3

New to Qlik Sense

Topics with Label: exclusion

SUM question with exclusion

Set Analysis. Final exclusion operator, with sum A...