Qlik.com | Qlik Help | Resources

Ask a Question

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

How to exclude data

by Latest post by

1 Reply 85 Views

1 Reply

85 Views

Synthetic Keys

by on Latest post on by

6 Replies 819 Views

6 Replies

819 Views

Creating a trendline.

by on Latest post on by

2 Replies 657 Views

2 Replies

657 Views

Data manipulation - Pivot - unpivot ? loop ? for? ...

by on Latest post on by

7 Replies 1401 Views

7 Replies

1401 Views

How to interlink to datasheets ?

by on Latest post on by

2 Replies 510 Views

2 Replies

510 Views

Treemap creation merging multiple headers and coun...

by on Latest post on by

1 Reply 608 Views

1 Reply

608 Views

Room Usage

by on Latest post on by

1 Reply 617 Views

1 Reply

617 Views

Subscribe by Topic

"colour" "bar chart" 1
"Data Handling" "Nested Ifs" "Multiple Conditions" 1
"data reduction" "section access" 1
"Função totais" 1
"gamma distribution" "passwords" 1
"Left Join within condition" 1
"Left keep" 1
$field 1
% 1
% of Total 2
' 1
'2-Develop' 1
'aggregate' 1
'comment field' 1
'comment table' 1
'condition' 1
'Filter' 1
'order by' 1
'Qlik Sense' 1
'Qlik' 1
'Sense' 'Install' 'Windows 16' 1
'where' 1
* values 1
** 1
- sign 1
-(aggr( formula 1
...................... 1
.json 2
.NET 2
.net api 1
.NET Core 1
.net framework 1
.net sdk 2
.qvf file 2
.qvf file error 1
.qvf file not opening 2
.qvs 1
.qvs file not working 1
0 values 1
000 1
000 only. 1
100% 2
100% Stacked Bar Chart 3
14days 1
2 Different dates in data model 1
2 dimensions 1
2 nodes 1
2 variables 1
20% 1
2020 June 1
2021 1
3-Tier architecture 1
30 60 90 Day Filter 1
3000 1
3D Scatter plot 3D Surface plot 1
4 weeks in Pivot table 1
400 Bad Request 1
401 Authorization Required 2
403 1
404 1
404 Error 1
4d 1
4dd 1
6 1
<dimension> 1
> 1
@Anil_Babu_Samineni 6
@CELAMBARASAN 3
@Dalton_Ruer 2
@Gysbert_Wassenaar 3
@Henric_Cronström 3
@Jagan 3
@jagmohan 3
@kaushiknsolanki 2
@kiranmanoharrode 1
@MarcoWedel 1
@marcus_sommer 1
@MayilVahanan 5
@mto 2
@Oleg_Troyansky 1
@OmarBenSalem 2
@OmarBenSalem @Dalton_Ruer 1
@PavanNallani 1
@pradnyan 2
@qlik sense 24
@qlikview 6
@rwunderlich 2
@Set Analyis 3
@sunnytalwar 18
@swuehl 5
@Taoufiq_Zarra 2
@tresesco 2
@vamsee 1
@vegar 2
a new field from already calculated fields LOAD 1
AAI 4
abbreviation 1
ABC analysis 2
above 15
above() 6
Above() function 10
above() in bar chart 1
absolute value 2
accent 1
accesos 1
Access 15
Access Control 4
Access Database 3
Access Denied 5
access issue 1
Access not updating 1
access pass 1
access rights 2
access rule 2
Access to a particular group by using binary load in server 1
Access to control centre of Qlik Sense 1
accessibility 1
accessing streams 1
AccessToken 1
accordion 1
account 1
Account Balance 1
account partner activate 1
account termination 1
accounting 2
accumulate 3
accumulate sum 1
accumulated 2
accumulated sum 5
Accumulation 5
accumulative line in combo chart 1
Acess 1
Acessar um dashboard a partir de uma intranet 1
ackumulated sum 1
acsii 1
action 2
action button 4
action in qliksense 3
Actions 7
actions and triggers 4
Actions Bookmarks Dates 1
active caption 1
Active Directory 6
Active employees 1
actual currency rate from National Bank 1
Actualizacion 1
Actuals 2
Acumula 1
acumulado 2
acumulados 1
acumulated 1
acumulative 1
AD 1
ad hoc report 1
add 4
Add AVG 1
add column 2
add data 3
add fields 1
Add fields dynamically to expression 2
add limit 1
Add new rows to an existing column 1
add rows 1
add user to app (Qlik Sense Server) 1
add zeros 1
addieren 1
addifset 1
Adding dynamic values 1
Addmonths 2
addyears 3
ADFS 2
adhoc 1
Adhoc & Dynamic Reporting in QlikSense 2
Adjust 1
Adjusting 2
Admin 8
admin roles 1
admin termination 1
Administration 6
Adopt the specific values with function: peek() 1
Advance Analytics 1
Advance scripting 1
Advanced Aggr 1
Advanced Analytics Toolbox 3
Advanced Authoring 1
advanced filtering 1
advanced maps 1
Advanced qlik 1
advanced text object 1
Advanced visualization 1
Advanced-analytics-toolbox 1
age 5
Age Bucket 2
age calculation 1
Age Count Countif 1
age formula 1
Age Grouping 2
age range 1
agg 1
Aggr () in KPI 1
aggr avg sankey 1
Aggr concat with count 1
Aggr Count 1
aggr function 6
Aggr GroupBY Year Help QlikSence 2
Aggr GroupBY Year Help QlikSense 1
Aggr Help GroupBy Year QlikSence 1
aggr if 4
AGGR in set analysis 15
Aggr Only 1
Aggr or Set Analysis 10
Aggr QlikSence Example 3
Aggr QlikSence Help GroupBy Year 1
Aggr Sum 12
AGGR() 16
AGGR() ordering 2
Aggr. Function 8
aggregate 18
Aggregate and Average 8
aggregate areas 1
aggregate count 1
aggregate sum 3
Aggregate value not showing in the sheet 1
aggregated 1
aggregated data 1
aggregated sum in matching fields 2
aggregating data 3
aggregating grouped dimensions 1
aggregating previous months 1
aggregation 22
aggregation function 3
Aggregation in script 4
aggregation in set analysis 1
aggregation with if 1
aggrigation 1
Aging 1
Agregate 1
agrupar 2
aider 1
aircraft 1
airline 1
alb 1
alert 3
alerts 1
Alias 2
alignment 2
all 1
all records 1
allocation 1
allocations 1
Alphabetic order 1
Alphanumeric Sorting in Qlik Sense 1
Alt 2
alternate 1
Alternate Dimensions 1
Alternate extension 1
alternate state 3
Alternate State complexity 1
Alternate State count filtered 1
alternate state with If condition 1
Alternate States 21
Alternate states dimension IF alternate states 2
alternative 1
Alternative dimension 2
alternative measure 1
Alternative Measures 1
Alternative state 1
alternativedimension 1
always one selected 2
always one selected value 1
Always One Selection 1
Amazon 1
Amazon Redshift 1
amazon S3 2
Amazon S3 Connector 2
Amazon Web Service (AWS) 2
amortization 1
AMP 1
an error has occurred 1
an error has ocurred 1
An error occurred 2
Analisis de conjunto 1
Analyses 1
Analysis 11
Analysis Services 2
Analyst Exam 1
Analytics 4
analyzer 6
analyzer allocations 1
Analyzer Capacity 1
Analyzer role 2
and 7
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 3
animated graph 1
Animator 1
anit join 1
annotations 1
annual 1
ANO-SEMESTRE 1
Anonymous users 1
another column comparison 1
any tool to convert Qlikview app to Qlik sense 1
AnyChart 6
AnyChart extension 2
AnyGantt 5
AnyGantt Extension 4
ao usar filtro não localiza dados 1
Apache 2
API GooglE Maps 1
API's 2
apiangular 2
APIs 4
app 7
App contents 1
APP Custom Properties 1
App Development 23
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 2
app objects 1
App Overview Improvement 1
app owner 1
app performance 1
app preload 1
app published date 1
app publishing 1
app reload 1
app security 1
App Size 2
App theme 1
appear 2
Appearance 1
append 5
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 9
Application Automation 3
Application Development 3
Application import error 2
application issues 1
application save failed 1
applicationmaintenance 1
applications 2
Apply 1
apply map 1
apply multiple changes 1
applymap 11
Applymap() 18
ApplyMapp 1
applymapping 1
Appointments 1
approval 1
approve 1
apps 9
appscripts 1
AppyMap 1
April 2019 2
Architecture 1
Archive 2
area 2
area layer 3
Area Map 2
areas 1
arquitetura 1
array 5
array type data load data base 1
arrg 2
arrows 1
Articles 1
Arvore 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
Assign Current User Name to Variable 1
Associate 1
associate table 1
Association 7
Association between two tables 1
association reccomendation 1
associations 6
Associative 1
Associative Insight 3
associative model 1
AsStaticHeaderUserViaProxy 1
Atlassian 1
attendance 1
attrition 2
attrition rate 2
audit 1
audit admin 1
auth link 1
Authenication 2
authenticate against qlik sense enterprise 1
Authenticate Qlik Desktop 2
authenticate qliksense desktop 1
authentication 12
authentication in qliksense 1
authorization 4
auto bookmark by sheet 1
auto calendar 3
auto calendar in semester to date 1
auto generate 1
auto generated Script 1
Auto Refresh 4
Auto resize 1
Auto Sum Total functions 1
auto zoom 1
auto-filtration 1
auto-select 1
Autocalander 1
autocalendar 7
autofill 1
autogenerate 3
Automated 1
Automated Data Exploration 1
Automated Mail 1
automatic 2
Automatic Field Filling 1
automatically 1
Automation 4
automise 1
AutoML 1
autonumber 3
autonumber() 2
autosave 1
autozoom 1
Autozooming in Qlik Sense 1
availability 1
Averag of weekdays 2
average 28
Average Calculation 9
average calculations 3
Average Count 3
Average Count Set Modifier 1
Average days 1
average formula 4
Average growth Rate of two measures 1
average line 2
average measure 1
average of quartile 1
Average reference line 2
Average Time Interval Duration 1
Average Trendline 5
averages 2
avg 13
avg daily 1
Avg Function 4
avg with many agg 1
avg() 2
AvgHeadcount 1
avinashelite 1
AvoidOverlapping 1
AWS 5
axis 6
Ayuda 6
Azure 4
Azure Cloud 1
azure devops 1
Año 1
Back button 1
background 5
background color 9
background color in button 1
Background color In pivot table 2
Background color in table 1
background color in tables 1
background colour 2
background expression 3
background image 2
Background Image in landing Page 1
backgroundColor 1
backgroundcolorexpressions 1
BackgroundColourExpression 1
backgroundexpression 1
backup 12
backup and restore 2
Backward Planning 1
balance 2
Balkendiagramm 1
banco de dados 1
Banding 1
Banner in QlikSense Hub 1
bar 9
Bar & Area Chart 10
Bar char 10
Bar Chart 2 dimensions relative percentage stack 2
bar chart comparisons 1
bar chart dimension 1
bar chart expressions 8
Bar chart sort 2
Bar Chart with Month and Year 1
Bar chart with values 10
Bar charts 22
Bar charts expressions 6
bar colours 1
bar graph 9
bar offset 1
barchart 23
Barchart - Rolling 12 months 1
barchartwithGroupedandStack 1
Bargraph 1
barras 1
barsplus 3
Bart chart with a filter of selection 1
BASE 64 1
based on field values 1
baseline 2
basic authentication 1
Basic Guidelines 1
Basic Training 1
Basics 3
basket 1
batch 1
before 3
before() 4
begginer 1
beginner 7
beginner help 4
below 2
below target positive 1
Best chart 1
Best Practice 1
Best Practices 12
between 4
Between Qlik Sense 1
between two dates 1
BI 3
Big Data 4
big query 1
Big Screen Dashboard auto refresh 1
bigquery 1
binary 1
binary chart 1
Binary Load 8
binary signal 1
bins 1
biweeklydate as dimension 1
bla bla bla 1
blank 6
blank fields 1
Blanks 1
blocks 1
blog 1
body parameters 1
bold 3
BOM 2
bookmark 13
Bookmark creation 1
bookmark Issue 1
Bookmark object 3
bookmark security Rule 1
Bookmark Set Expression 1
Bookmark sharing 1
Bookmark Trigger 2
Bookmarks 15
Bootstrap 1
borders 2
BOT 2
bottom 1
Bottom 10 values 1
botão 1
box 1
box filter YTD 1
Box Plot 6
boxplot 3
brackets 1
branch 2
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 2
Bubble Dimension restrict 1
bubble layer 1
bubble size 1
Bucket 1
Bucketing 3
buckets 6
Budgeting 1
bug 13
Bugs 6
Bugs & Errors 29
bulle 1
Bullet Chart 2
Bullseye Chart 1
business 2
Business Analyst 5
business days 1
Business Intelligence 5
business logic 1
business trial 1
but the User dont see anything 1
but user able to access other reports(QMC) 1
Butterfly chart 1
button 15
Button Actions 13
button extension 3
button for navigation 3
Button Navigation 2
Button to select Field 8
Button to switch betweeen languages 1
button. 1
ButtonActions 4
buttons 6
Buttons. 1
by 1
by date 1
by expression 1
by month 1
ByExpression 1
bytes 1
C sharp 1
CA certificates 1
CAC 1
Cache 5
Cache objects 1
cache warmer 1
cache_warmer 2
cached memory 1
calander 1
calculate 3
calculate a measure between two dates 1
Calculate Aggregation 2
Calculate Count of Unique ID with Grouping in Qliksense 1
Calculate dimension 1
Calculate percentage 3
calculate percentage using total in table. 1
calculate total with variables 1
Calculate ytd values 1
calculated column 1
calculated columns 1
Calculated date 3
Calculated Date Dimension 1
Calculated dimension 21
Calculated Dimension Colors 1
calculated dimensions 5
calculated field 21
calculated fields 5
calculating 1
calculating age 1
calculating conditions 1
calculating dates 1
calculating values in script 1
calculation 13
Calculation Condision 2
Calculation Condition 6
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 support 1
calculation timed out error 1
calculations 12
Calendar Control 2
Calendar Extension 2
Calendar Measures 3
calendar script 2
Calendar table 6
calendar view 1
Calendario 3
calendars 2
Calender 3
Call 1
Call center 2
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 3
Canonical Date 4
cantidad 1
capability api 6
capitalize 1
capture 1
capture the last loaded value 1
capture the records that have 2 data loaded with a specific value 1
Car 1
cardinality 2
care 1
Carga com o arquivo atual 1
Carga Fichero 1
Cargar archvo excel 1
carte 1
Cascading 1
case 1
case insensitive 1
Case Sensitive 1
Case Statements 1
case when 3
Cashflows 2
categoria 1
categorical 1
Categorize 3
category 7
Category Categorization Override 1
CEF Error 1
cell 1
cell value 1
cells 1
celula tabela data 1
Central Node 1
certain row no 1
certficate 3
certificate 5
certificate security 1
Certificate Verification 2
certification 9
Chaining 1
challenge 4
change 6
Change color 1
change date 1
change default colors 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 3,402
Chart bar 8
Chart Exclusion 1
chart expression 9
chart expressions 18
chart filter 1
chart function 2
chart functions 5
chart interaction 3
Chart label 1
chart legend 1
Chart level grouping 1
Chart Line 3
chart mesaure script 1
Chart Object 12
chart properties 1
Chart reference lines 1
Chart Selection 3
chart selections 1
chart sense color 2
chart should not change values on the selection made on it 1
chart title 1
chart with three columns 1
Charts Select 4
chatbot 2
CHAVE 1
check 3
Checkbox 1
checked 1
checksum 1
chennai 1
child 1
chr(39) 1
chrome 2
circle reference 1
Circular Reference 5
Circular reference error 1
circular_reference 2
Claim Line 1
claims data financial data 1
class 6
class function 1
class() 2
classification 1
Clean 2
clean output 1
Cleansing 1
clear 1
Clear filter 1
clear selection 2
ClearAllTrigger 1
ClearFields 1
Cli 3
click cell 1
client auth link 1
Client Authentication 1
Client authentication link 1
Client Managed 1,331
Climber 3
climber cards 2
Climber Container 1
climber kpi 1
Climber Selection Bar 2
Closing 3
Cloud 11
Cloud Business 6
Cloud Sense 6
Cloud services 2
Cloudera 1
cluster 2
CMD 2
Code 2
code release impact 1
Code Validation 1
coding 1
cohort 1
coldfusion 1
collaboration 1
Collaborative Notes Overview 1
Collapsible Dimension 1
collation 1
collections 1
color area layer 1
Color background in pivot table 5
Color blind 2
color by conditions 3
color by dimension 3
color by dimension and by measure 1
Color by dimension value in qliksense 5
Color by dimension value in qlikview 1
color by expression 12
Color by measures value in qliksense 5
color by trend 1
color change 1
Color coding 6
Color Coding Logic for Pivot table 4
Color condition error 2
color condition on text box 1
Color conditioning 1
color de fondo 1
color dimension 2
color expression 7
color expression for numberintervall 1
Color for measure 2
Color formatting 3
color line chart 1
color line chart by trend 1
Color linked 1
color measure 2
color mix 1
color of labels 1
color schema 1
color text 1
colorchange 1
Colorear número en gráfica 1
COLOREAR POR EXPRESIÓN CUARTIL INFERIOR-SUPERIOR 1
Colorexpressions 1
coloring 3
coloring of total depending on subtotal 1
coloring pivot table 2
ColorMix 5
colormix1 1
colormix2 3
Colors 11
colour 6
COLOUR BAR GRAPH MEASURE 2
colour by expression 4
colour change 3
colour selection 1
colourblind 1
ColourbyExpression 2
ColourByMeasure 2
colours 1
column 22
column dimension 3
column headings 1
column hide 1
Column labels 1
column limitation 1
column name 1
column order 2
column resize 1
column table criteria 1
column table measures 1
Column Total in P&L pivot table 1
column width 1
columns 6
columns change 2
columns dynamically from excel sheets 1
Columns to Rows 1
Coluna 1
coluna dias atrasados 1
combi diagram 1
combination 1
combination chart 1
combine 5
combine dimensions 2
Combine fields 7
combine master item 1
Combine of flags 1
Combine rows 2
combined chart 4
combining 1
combining tables 2
combo 2
Combo chart sorting 1
combo charts 4
combochart 2
Combustible 1
comma 1
comma separated 1
commands execution 1
Communication 1
Community Corner 1
Community Document 2
Community Help 13
community sheets 1
communtiy 1
Como incluir uma imagem no dash usando uma claúsula de condição 1
Comodo 1
Comparation 2
COMPARATIVE 3
comparative analysis 8
comparative field 1
compare 12
Compare date 3
Compare Dates 1
Compare Dates in between in another column 1
compare dimensions between rows 1
Compare Field with other Field in same dimension 3
compare fields script 1
compare numbers 2
compare range with each other 1
Compare rows of same table and Create flag 1
Compare same periods different years 1
compare two columns 2
compare two values 1
Compare Values Qlik Sense Help 3
compare_periods 1
CompareValue Compare SameTable Qlik HelpPlease 3
Comparing Dates 2
Comparing the datas 2
comparison 13
comparison between months 6
Comparison Type 1
comparison via set expression 1
comparison_period 1
compatibility 1
Competitive analysis 1
Compiled Open Source Plugins 1
complete row lines with data 1
complex measure 1
complex OMIT 1
complex pivot 1
complex Reduction 1
composite key 5
composite keys 2
compression 1
Concat 14
Concat on two generic fields 1
Concat value 2
Concat() 2
concatenante 1
concatenar columnas osticket concat columns NA 1
concatenat 1
concatenate 17
Concatenate 2 Fact tables 1
Concatenate based on list 1
concatenate expressions 2
Concatenate fields 3
Concatenate more rows to one row 2
Concatenate x Lef Join 1
concatenated 1
Concatenating data 4
Concatenating data monthwise 1
concatenation 4
Concescutive 1
condiciones 1
condition 7
condition based count 1
conditional 9
conditional collor 3
conditional color 2
conditional colors 3
Conditional Column 8
conditional count 2
Conditional Date Format 2
conditional dimension 1
conditional display 3
Conditional Display of Measures 5
conditional expression 2
Conditional Expressions 16
conditional filter 1
Conditional format 4
Conditional formatting 12
Conditional formatting in Qliksense 3
conditional group 1
Conditional images 2
conditional load 1
conditional set analysis 1
conditional show 1
conditional split 1
conditional statement 1
conditional sum 2
conditional sum with variables 3
ConditionalExpressions 13
Conditions 12
Conditions matching 2
conector 1
conector web 1
Configuration 36
connect 1
Connect Google Analytics Google Big Query Error assigned catalogs 1
Connecting to DerbyDB 1
Connecting to GCP using Qliksense 1
Connecting to QlikSense via .NET SDK 2
connection 17
connection error 4
Connection issue 2
connection lost 6
Connection Microsoft Access 365 Database 1
connection string 3
Connection to Qlik Sense Engine Failed 1
connections 9
Connectivity 1
Connectivity - Sources or Targets 5
Connector 11
connector error 1
Connector reply error 2
Connectors 7
consolidate 2
Constant 2
constraint 1
Consumer 1
Consumer Node 1
Contador de datos sin repetición 1
container 12
containers 4
contar 1
Contar un solo criterio 1
contcat 1
content 2
content admin 1
content library 4
context 2
context menu 1
continuopus classroom 1
continuous 2
Continuous Classroom 1
continuous data 1
continuous scale 3
continuous Service 1
Continuous Value (Data) 1
contraseña 1
contributors 2
Control Chart 2
control dimension values 1
Conversion 6
conversion table 1
convert 7
convert monthly to daily 1
convert numbers to words 1
convert problem 1
convert qlikview to qlik sense 1
convert sql to qlik code 1
convert string to number 1
convert tiff files 1
converter 3
converttolocaltime 2
Coomand to execute QS 1
coordinates 4
copy 3
Copy Value 1
Copying data 1
cores 2
correl 1
Correlation 2
Correlations 1
Corrupt 1
corrupted data 1
cors 2
CORS Vulnerability 1
Cost 2
CouchBase 1
Count 17
count according to rank 1
Count Aggr If 10
Count based on another counted field 5
Count Blank 1
Count clarification 1
count count it 1
count days between two dates 1
count distinct 3
Count Distinct by Multiple Criteria with Max Date 1
Count Distinct if 2
count duplicate 1
Count formula 1
Count if 12
Count if condition 7
count if date filter 1
count if null 1
COUNT if two conditions 12
count number of date 1
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 10
Count Rank 1
Count Rank QlikSence Help 1
Count record by data 1
count rolling 12 months 1
count rows 1
count session active 1
Count sheets 1
count the number of projects 1
Count top 10 from table 1
Count unique 1
COUNT UNIQUE OCCURENCE 6
count with condition 1
Count with If condition 2
count words 2
count() 6
count(distinct ) 1
countDistinct 1
counter 3
Counter Field 1
Countif 4
Countifs 1
counting 3
counting words 1
Countries 2
Country based on city 1
counts 3
COVID-19 2
cpu 2
Crash 2
create 1
CREATE "CALENDAR" 1
Create a intervall from single column 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 from one data-column two columns 1
Create in Scriptarea the key figures (as one expression) 1
create new app 2
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 of filter with: if then 1
Creating Relations between two tables in a Load Script Editor 1
Creating start and end time from changing dimension 3
creation of backward data field 1
Credentials 1
criteria 2
crm 1
Cross App data selection 1
cross filter 1
cross hub access 1
Cross Tab 3
Cross Table 12
cross table in qlik sense 2
cross tables 1
Crosstab 1
crosstable 22
Crosstable multiple rows 1
Crosstable or another way of tabletransforming 1
CrossTable with multiple columns 3
Crosstable(transforming of table) 2
CSR 1
css 18
cst 1
CSV 13
CSV file upload to QLIK Sense Cloud 2
CSV to QVD without Qlik 1
cte 1
Cube 2
Cummulative 8
cummulative sum 3
cumul 1
Cumul Value while Selection 1
Cumul Value within Pivot plus Dimension (horizontal) 1
Cumul Value within stacked barchart 1
cumulative 12
cumulative % 2
Cumulative calculation using range sum function 3
cumulative chart 1
cumulative count 3
Cumulative count with 2 dimensions in a bar chart 1
Cumulative counts for multiple dimensions 1
Cumulative Returns 1
cumulative sum 3
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 2
cumulativesum in Qliksense 1
cumulul value in depence on moths 1
Currency 1
currency exchange 1
Currency Rate 2
current 2
current cell value 2
current month 3
current month like period 1
Current Selection 2
current selections bar 1
Current Week 1
Current Year 4
Current year vs last year 1
curva abc 1
custom 7
custom chart 2
custom classification 1
Custom Color 3
Custom Component 3
custom date filter 2
Custom Dimension 1
Custom Extension 2
custom field 3
custom limitation 1
custom measure visibility 1
custom measures 2
Custom Message 1
custom objects 3
custom pie chart 1
Custom Production Hours 1
custom properties 5
custom property 1
custom region 1
custom reports 2
custom sort 4
Custom Sort Order in QlikSense Treemap 1
custom sorting 2
custom theme 3
Custom Themes 2
custom tooltips 1
Custom UI 1
custom variable 1
custom week 1
Custom year 1
CustomConnect 1
customer 1
Customer Value 1
customers 1
Customers bought 1
Customization 7
Customize 3
Customize color 1
Customize my Home 1
customized calendar 2
Customized Filters 1
customized log files 1
Customized measures 1
customized tooltip 1
CustomProperties 2
customreport 1
cut 1
cut off 1
CVS 1
cyclic dimension 1
código 1
d3 1
D3 Extension 2
d3.JS 3
Daily 1
daniel coullet 1
Dashboard 23
dashboard bundle 7
Dashboard Extension Bundle 5
dashboard issues 4
dashboard txt file 1
dashboards 2
data affected in one filter only. 1
data aggregation 1
Data Analytics 12
Data Architect 8
Data Architecture certification 1
Data cleaning 2
data cleansing 1
Data Connection 14
data connections 8
Data Connections QMC 1
data connectivity issue 1
data connector 3
data connectors 1
Data Consistency 2
data converting 1
data cube 1
data currently not existing 1
Data Dictionary 1
Data display for Previous year along with previous year records 1
Data download to excel 1
Data Encryption 1
data exhaustivity 1
Data Export 1
data extraction 1
Data Extraction Issue 1
Data File Name 1
data filtering 2
data format 3
Data From folder 2
data handling 1
Data in Qliksense cloud 1
Data Integration 1
data island 1
data labels 3
Data limitation 1
data load 34
Data Load Editor 3,547
Data Load Error 7
data load fail 1
Data load issue 2
data load problem 1
data load script 2
data loading 4
Data Loading from Source 4
data manager 16
Data Manipulation 4
Data Mapper 1
data masking 1
DATA missing error 2
data mode 1
Data Model 26
Data model Issue 2
Data model viewer 5
data modeling 4
data modell 1
Data Modelling 18
Data Prep 1
Data Preparation 7
Data Presentation 1
Data Quality 2
data range 1
DATA REDUCTION 6
data refresh 1
Data Science 1
data source 2
data sources 1
Data Storage 1
data table 1
data transfer tool 1
data transformation 5
data type 2
data types 3
data upload 1
data validation 2
data visualization 6
Data Warehouse 1
data wrong showing using script editor 1
database 10
database connection settings 1
database connnection 1
database dynamically 1
Database Error 2
Database Query 2
Database Update 1
Dataconnections 2
datafiles 1
Dataflow 1
dataload 7
dataloadeditor 3
Datamanager 3
Datamodel 4
datamodel logic 2
datamodeling 1
datamodelling 1
datapoint 2
datapoint and datalabels 1
Datapoints 1
datarestriction 1
DataSet 4
datatransfer 1
datatype 1
datawarehouse 1
DataWarehousing 2
Date 3
Date & Time 21
Date Bucket 4
date conversion 2
date convert 1
Date converting 6
date data 2
date data exhaustivity 1
date difference 2
date dimension 1
Date Dimensions 6
Date Expression 18
date field 2
Date filter 14
Date Filter selection 5
date format 16
date format not respected 1
Date format wrong. 1
date formatting 4
Date formula 2
Date Functions 18
date groups 1
Date Help QlikSence TimeInterval 1
Date in dimension for Line chart 1
date picker 20
Date Picker Extension 9
Date Picker Extension not recognize Field 2
Date Picker. 4
Date Range 32
date range picker 3
Date range picker extension 4
date range selector 1
Date ranges 6
Date set 3
date settings 1
Date time 2
Date Time interval 1
date time timestamp 2
DATE VALUE 18
Date value to levels 1
Date Variable 2
Date WhereClause 1
date(0) 1
DATE_IN and DATE_OUT in Master Calender 3
datefield 1
Datefield not recognized as Date 1
DateFilter 2
DateFormat 5
DateFormatting 1
DateMonth 1
dateperiod 1
datepicker 6
daterange 2
Daterangepicker 3
dates between 6
dates comparison 2
Dates differenece in days 1
Dates Help 11
dates period 1
Dates Set Analysis 7
Dates Transformation with different formats to single format 1
datesinperiod 1
datestamp 1
datetime 2
datetime stamp transformation 1
DateTimeformat 2
datevariable 1
datewithinadate 1
Datum 3
DAX 1
Dax Query 1
day 3
day count 1
day wise data 1
day(today()) 1
DayName 1
dayofweek 1
days 3
Days of current month 1
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 2
decimals 3
declare 2
default 4
default bookmark 2
default filter 2
Default Filters 1
default search mode 1
default selection 4
Default selection :: filter 1
Default Settings 2
default sheet 1
default value 2
default values 2
default view 2
defaultbookmark 1
define dimensions 1
define measure 1
defining geography 1
Defining Variable DataLoadEditor 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 4
Delimiter Split and matching 1
Delimiters 1
delivery on time 1
delta 1
deltaload 2
demension limit 1
demo 3
demo trial 1
demos 2
demos for both qlikview and qlik sense 1
Denominator 2
density plot 1
Dependencies 1
Dependency Explorer 1
deploy apps via api 1
Deployment 4
depreciation 1
derive 2
Derived 1
derrive 1
descending 1
description 1
descriptive 1
design 12
Designer 3
Desktop 12
desktop authentication offline corporate internet filtered blocked 1
desktop client 4
Desktop Download 1
desvest 1
detach object 1
Detailed Drill Down 1
Details 2
Dev Hub 8
deve 1
Developer 9
Developer license 1
Developers 3,851
Development 16
devhub 1
deviation 1
devtools 1
diagram 7
Diagramm 2
Dialog 1
Diarias 1
diff% 1
differance 1
difference 1
Difference Between Dates 1
Difference between two dates 1
difference between View and Sense 1
Difference in Week 1
different 2
Different dates 1
different measures 1
differential load 1
Dimensiom 4
dimension 3,479
Dimension as expression 18
Dimension axes 2
dimension counting 1
dimension expression 1
dimension Filter 1
Dimension grouping based on another dimension 3
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
dimensionality 1
Dimensiones 10
DimensionLimit 1
Dimensions as Measures 1
Dimensions grouping 2
dimensions in formula 1
dimensions in pivot 1
dimensons 1
Dimensão 1
Dimensões de uma imagem para não ficar distorcida no Qlik 1
dimesions 1
Dimesnion % Calculation 1
Direct Discovery 1
Direct Query 3
directory 1
DirList 1
disable chart interaction 1
disable selection 2
disable selection on filter 1
disable standard mode 1
disaggregate 1
disaster recovery 1
discrete points 1
discrete values at all levels 1
Disctinct 2
discussion forum 1
display 4
display common items between two displayed tables 1
display if blank 1
Display label 1
Display Rows 1
Display Table 1
display tiff files 1
Display website dynamically 1
disregard filter Date 1
dissapear 1
distance 1
Distinct 25
distinct count 2
Distinct field values 1
Distinct List 1
distinct sum 2
Distinct values 5
distribute volumes 1
distribution 2
distribution curve 1
distribution plot 7
Distribution Task 1
divide 4
Divide with same column 1
division 3
Division by Variable 1
DM 1
DNS 1
do 1
do while 3
Do While Loop 2
Do While loops 1
Doc 1
DocAnalyzer 1
Document Analyser 2
Document analyzer 3
document analyzer connection error 1
Document Chain 1
Document Chain in Qlik sense 1
document chaining 2
document chaining using Field value in Qlik sense 1
Document Information 1
Documentation 4
Documents 1
Dollar expansion 5
Dollar Sign 4
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 2
dots 1
double counting 1
Double Dimension 1
double match 1
Double Quotes 1
double values 1
down 1
downlaod 1
Download 8
drill down 12
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 2
drop down 1
drop down select 1
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
dst 1
dual 8
dual data type 3
Dual date 1
dual function 4
Dual Set Expressions 2
Dual Use 2
Dual() field 1
duplicate 5
duplicate column names 1
Duplicate data 3
duplicate entry 1
duplicate fields 2
duplicate records 2
Duplicate Rows 8
Duplicate SAMAccountName Network login account 1
Duplicate sheet private wdc 1
duplicate values 2
Duplicate values in pivot dimension 1
duplicate values in straight table 1
DuplicateApp 1
DuplicateID 2
duplicates 6
duration 1
Duties 1
dynamic 18
Dynamic Assignment 3
dynamic bookmarking by sheet 1
Dynamic Calculated Measure 1
Dynamic Charts 4
dynamic data load 1
dynamic date expression 1
dynamic dimension 2
dynamic dimension as variable 2
Dynamic Dimension labels in Title 1
dynamic field name 2
Dynamic filter 3
DYNAMIC FORMULE 1
dynamic join 1
Dynamic KPI 1
dynamic label 2
dynamic labels 1
Dynamic legend 1
dynamic measures 3
dynamic path 1
dynamic report 1
dynamic select 1
Dynamic selections 3
dynamic text 2
dynamic title 1
dynamic update 1
dynamic URL 1
Dynamic value 2
Dynamic Value List 1
dynamic variable 2
Dynamic views 1
dynamic way of replacing 1
DynamicColumns 1
Dynamics 365 1
Dúvida 1
E() 1
each 1
easy to understand 1
Ebiexperts 1
EC2 1
ecuation 1
edit 2
edit data 1
edit email 1
Edit Name of Downloaded Data File 1
edit variable 1
Editing an app 1
editor 3
EDX tasks 1
efficiency 1
else 1
Else Max Date 1
email 7
email alert 7
email hyperlink 1
Email Notification 2
Email Server 2
Embed 5
Embed button to web page 1
embed iframe 1
Embed QlikSense Sheets 3
Embed Sheet 7
Embedded 3
embedding 4
empleados 1
employee status 1
employees 1
Employment opportunity 1
empty data 3
empty values 1
enable 1
enable conditionals 1
enable-non-published-sharing 1
Encode 1
Encounters 1
encryption 2
end date 3
end of file 1
end time 1
enddate 1
Engine 5
engine api 4
Engine is not alive 1
Engine Services 1
EngineAPI 1
Enhancements 1
Enigma 3
enigma.js 3
Enter 1
enterprise 10
enterprise version 3
Entitlements & Permissions 2
Entwicklungsumgebung (wo am besten entwickelt werden muss) 1
Environment 1
equal 1
ErikWetterberg 1
error 29
error 1603 1
error 400 1
Error 500 1
error bars 1
error code 9010 1
error handling 1
error log 1
Error Message 5
Error Messages 3
Error on the hub area 1
Error ORA-01456 Qlik Sense 1
ErrorCode: 4294967192 1
Errorhandling 1
errors 1
Errors - Unexpected Behavior 11
es6 1
Español 2
Esri 1
estado 1
estados alterno 1
etc. into white 1
etiquette 1
ETL 6
Event 2
Events 4
Everyone 1
evolution 1
exact 1
exact match 1
exact string position 1
exam 2
example 1
Example AAI QVF FIles 3
Examples 1
excel 29
Excel data 19
Excel data sets to Qlik 5
excel date format 1
excel export 1
Excel export wrong data 1
Excel Exports 10
excel file 2
Excel import hard disk local file 1
Excel load to Qlikview 1
excel macro 1
Excel pivot data into qlikview 1
Excel Pivot table 2
excel sheets 1
Excel via ODBC 4
excel worksheets 2
except 1
exchange Rate 1
exclude 10
exclude data 4
exclude data in column 1
Exclude dimension selection in filter pane 1
exclude legend 1
exclude value 1
exclude values 2
exclude values in column 1
excluded 1
Excluded Values 2
ExcludedValues 1
excluding 1
Excluding Selections 1
exclue 1
exclusion 3
execute 1
Execute Command 1
Execute Command in Script 2
execution 2
execution time 1
Exhaustive Dates 1
exist 1
Exists 6
Exists() 3
Exluding Entrie patterns 1
Expand 1
expand only left rows 1
Expandissue 1
expansion 1
explaining techical terms 1
Export 17
Export as unicode txt format 1
Export ContextMenu 1
EXPORT CSV 5
export data 8
Export data to excel from qliksense 1
Export data to google spread sheet from CSV file in qlik sense 1
export excel 2
export expression 1
export image 2
export powerpoint ppt 2
Export Script 1
export sheet 2
export to CSV variable automatically export 1
export to excel 6
export to image 1
export to pdf 3
Exportação de dashboards para PDFs 1
exportData 1
ExportDataFileName 1
Exporting data 8
expresion 1
expresiones 1
expresión 1
expression 6,265
Expression builder 13
expression by color 1
expression editor 4
Expression Error 16
expression for reference line 1
expression issue 2
expression to total column 1
Expression Total 2
Expression value selection in to dimension 2
expressions straight table 2
extended sheet 1
extending rows in Qliksense 1
extension - IE issue 1
Extension Development 7
Extension Error 1
Extension Object 1
Extension Objects 10
Extensions 18
extensión 1
External 2
external data 1
extra data point 1
Extract 6
Extract Date from String 1
Fact 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 2
Failed To Invite new members 1
Falha ao abrir hub selecionado 1
family 1
feature 3
Feb 2019 1
Feb 2020 1
February 2019 3
Fecha 2
Fechas 1
Feld duplizieren 1
Fetching Data through rest connector from OrientDB in Qliksense 1
field 13
field addition 2
field as variable 1
Field Load 8
Field name 3
field not found 4
field not found error 4
field over field 1
Field renaming 1
field selection 1
Field Type 3
Field value 6
field values 1
fieldIndex 1
fieldname 1
FieldNumber 1
fields 12
fieldvalue 4
figures 1
filas 1
file 5
file comparison 1
File Detection Trigger 1
File Explorer 1
File format 1
File name 2
File not found error 1
File Parameter 1
file path 2
File upload 1
FileName() 1
files 4
filesize 1
FileSizeMultiplier 1
filesystem 1
Filetime 3
fill 1
fill out the tows 1
filling Data field based on previous row 1
Filling Fields 2
filling missing date 1
filter 2,910
filter actualdate date currentDate setCurrentDate 1
filter by 1
filter by boolean 1
Filter by Data Types 1
FILTER BY DATE 6
Filter by default 1
filter by dimension 2
Filter by multiple values 1
Filter by value 2
filter comma separated 1
Filter condition +Condition Filter - Need help here 4
Filter confirmation 2
Filter DataSource 2
Filter Date 7
Filter Dates 5
filter dependency 1
Filter dimension 1
Filter dimension measure 5
filter expression 2
filter if 1
Filter in data loading 1
filter label 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 with color 1
filter panel 8
Filter panel sort 1
Filter Panes 13
Filter performance 1
filter pivot 3
filter selections 5
filter sum qlik sense 1
filter triggers table creation 1
filter value 3
Filter Visualization 9
filter_tables 1
filtered 1
filtering 9
filtering a bar chart 1
filtering a measure 1
filtering date 1
filtering NULL values 1
filterpane 5
filterpanel 1
filters 24
filters in expressions 1
filters list functions 1
Filterselektion ignorieren 1
filtro 3
FILTRO FECHA SIN VALORES QLIKSENSE 1
filtro na horizontal 1
Filtros 11
Finacial Year 2
Financial functions 1
Financial model 1
financial year 2
Find 3
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 1
First Date 2
First value 3
FirstSortedValue 30
FirstSortedValue in Script 1
FirstSortedValue() 6
FirstValue LastValue 1
Fiscal 1
Fiscal Calendar 1
Fiscal Quaters 1
fiscal year 8
Fiscal Year Calculations 3
fiscalyear string orders 1
fitness 1
Fitting 1
fix 1
Fixar 1
fixed 1
FIXED DIVISION 1
fixed value 2
fixed variables 1
flag 12
flag count 1
FLAG Creation 4
Flag for aggregated values 3
flagging 2
flags 2
Floating 1
floor 1
Floor Map 1
floor plan 1
Flow 2
FlowChart 1
Focus 1
folder 4
folder connection 2
FolderAccess 1
Folders 2
font 3
font color 2
font color script 1
font size 4
font-family 2
fonts 2
Footer 1
for 5
for each 1
for each Next 2
for loop 12
For loop file store 1
for next 3
forEach 1
Forecast 10
forecast data 1
Forecasting 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 22
format applied on data cell 1
format date 4
format num 1
format numbers 2
format pattern 1
Format Specification Item 2
format string 1
Formating 10
formato 1
formats 1
formatting 13
formatting date 2
formatting dates 1
formatting issue 2
Formatting Rules 2
Formel 1
formula 23
formula filter 2
formula sum 1
Formula visible 1
Formular sum 2
formulas 3
Formules 5
Fort 1
FQDN 1
fractile 3
frame 1
framework 1
frecuency 1
Free text 1
Freelancer 2
freeze pane 3
from 1
From Folder 1
front end 2
Front End Help 1
front-end 4
frustrated 1
FTP 1
FTP SFTP Connector 3
Fuel 1
full 3
full reload 1
Full row duplicates 1
full screen 2
fullscreen 2
funcion 1
funcionalidades 1
Función 1
function 23
function in element list 1
function in variable 1
function list 2
Functionality 13
FunctionAsVariable 1
functions to a drop down list 1
funnel 5
funnel chart 4
fusion chart 1
future cash flows 1
Future values 1
fuzzy 3
Fuzzy search 1
Fx 1
FY 2
G 1
g3 Broker API 1
Gannt Chart 2
gantt 7
Gantt chart 10
gauge 3
gauge chart 6
Gauge chart (street light) 1
Gauge chart Limits 1
gauge chart percentage 1
Gauge Chart reference line 1
gauge chart- expression doubt-to show latest yearmonth data as default 1
gauges 1
gb 1
General Question 5,974
General QuestionClient ManagedSaaS 1
generate 2
generate date time 1
generate missing data 2
generate values within datafield 1
Generating Months 1
Generation 1
generic 1
Generic calendar 1
generic ldap 1
generic load 3
Geo 2
geo analytics 1
Geo Code 1
geo data 2
Geo location 2
Geo Maps 4
GeoAggrGeometry 2
Geoanalytic 1
GeoAnalytics 12
geoanalytics Qlik sense 1
geocodes 1
GeoCoding Geomapping 1
geodata 1
Geodata layer 1
geodatabases 1
geographic polygons 3
geography 1
GEOJson 1
geolocation 2
geomakepoint 2
GeoMapping 2
geomaps 2
geometry 1
GeoOperations 2
GeoPoint 1
GeoQlik 2
GeoTag 1
GeoTagging 1
get 1
Get Cells from all apps 1
get data from table 1
get field selections 1
Get rid of Duplicates 1
GetCurrentSelections() 2
getfieldselection 2
GetFieldSelections 13
getfiledselection 1
GetObjectDimension() 1
GetObjectField() 1
GetobjectMeasure() 2
GetSelectedCount 4
GetSelectedCount() 1
getselections 2
GetSheets 1
Getting Started 2
Getting Started Webinar 8
Getting the total for 1st and 2nd filter values 1
gigabytes 1
GIS 1
github 1
global filter 1
Global Grouping 1
Global Variables 1
glossary of items 1
GM% filter 1
Gmail 1
GNSS 1
Google 1
google analytics 4
Google Big Query 1
GOOGLE CHRME 1
Google cloud platform 1
Google Drive 1
google drive connector 2
google forms 1
Google road maps in qliksense 1
Google Sheet 1
google sheets 1
google spreadsheets 1
Googleapis 1
Governance 2
governance dashboard 1
gps 1
GPS co-ordinates 1
gradient 3
grafico 5
grafico de barras 4
grafico de torta 1
grand total 2
granularity 2
Graph 28
graphics 2
graphique 2
Graphs 2
greater 2
greater than 5
greater than equal to 1
greater than in measure 2
greater then 1
greater_than 1
greatest 1
greybar 1
grid 3
Grid chart 1
grid height 1
gridlines 1
group 11
group bar chart 1
group by 23
Group by in Load 13
GROUP BY ISSUE 11
Group data 4
group dimensions 2
group nodes 1
Group_Discussions 3
groupby 3
Grouped Bar Chart 6
Grouped data 3
grouping 7
grouping flaw 1
Grouping line chart 1
grouping values 2
groupings 1
Groups 1
growth 2
Growth pivot table 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
Hana 1
hardcode expression qliksense KPI 1
hardcoded value KPI expression qliksense 1
Hardware 1
having 1
HC 1
headache 1
Headcount 3
header 6

New to Qlik Analytics

Topics with Label: Data Preparation

How to exclude data

Synthetic Keys

Creating a trendline.

Data manipulation - Pivot - unpivot ? loop ? for? ...

How to interlink to datasheets ?

Treemap creation merging multiple headers and coun...

Room Usage