Index
A
- ABC analysis
- creating / Creating an ABC analysis, How to do it…, How it works…
- Aggr()
- using, with Rank() / Using Rank() with Aggr, There's more…
- used, for combining set analysis / Combining set analysis with Aggr, There's more…
- alternate states
- approved sheets
B
- bar chart
- performance measure, highlighting / Highlighting the performance measure in a bar chart, How it works…
- Basket Analysis
- intersection, using between sets / Using the intersection between sets for Basket Analysis, How it works…
- box plot charts
- used, for measuring statistical data / Measuring statistical data with box plot charts, How it works…
- Business Intelligence (BI) / Introduction
C
- Calendar fields
- generating, with Declare functions / Using the Declare and Derive functions to generate Calendar fields, There's more…
- charts
- limitations, applying / Applying limitations to charts, There's more…
- alternative dimensions, using / Using alternative dimensions and measures, How it works…
- alternative measures, using / Using alternative dimensions and measures, How it works…
- code
- packaging, in script files / Packaging the code in script files, How it works…
- colormix1 function
- command line programs
- executing, within script / Executing command-line programs within the script, There's more…
- community sheets
- comparison sets
- using, in Set Analysis / Using comparison sets in Set Analysis, How it works…
- composition / Composition, There's more…
- Concat() function
- using, to store multiple field values in single cell / Using the Concat() function to store multiple field values in a single cell, There's more…
- used, for displaying string of field values as dimension / Using the Concat() function to display a string of field values as a dimension, How it works…
- used, for capturing list of field values in Set Analysis / Capturing a list of field values using a Cconcat() function in Set Analysis, How to do it…
- content
- creating, to story / Creating and adding content to a story, How to do it…, There's more…
- adding, to story / Creating and adding content to a story, How to do it…, There's more…
- cumulative effect
- analyzing, with waterfall chart / Using a waterfall chart to analyze the cumulative effect, How it works…
- currency exchange rate calendar
- creating, with Peek() function / Using the Peek() function to create a currency exchange rate calendar, How it works…
D
- Dashboard Analysis Reporting (DAR) / Introduction
- data
- extracting, from databases / Extracting data from databases and data files, Getting ready, How to do it…, There's more…
- extracting, form data files / Extracting data from databases and data files, Getting ready, How to do it…, There's more…
- extracting, from web files / Extracting data from web files, How it works…
- extracting, from FTP server / Extracting data from the FTP server, Getting ready, There's more…
- extracting, from web services with REST Connector / Extracting data from web services with REST Connector, How it works…
- previewing, in Data model viewer / Previewing data in the Data model viewer, There's more…
- data-manager model viewer
- visual-data preparation, using / Using visual data preparation on the data manager model viewer, How to do it…
- databases
- data, extracting / Extracting data from databases and data files, Getting ready, How to do it…, There's more…
- data files
- data, extracting / Extracting data from databases and data files, Getting ready, How to do it…, There's more…
- Data model
- viewing / Viewing the data model
- associations, viewing / Viewing the associations
- table metadata / Table metadata
- Data model viewer
- data, previewing / Previewing data in the Data model viewer, There's more…
- Master Library, creating / Creating a master library from the Data model viewer, How to do it…, There's more...
- data relationships / Relationships, How it works…
- Declare functions
- used, for generating Calendar fields / Using the Declare and Derive functions to generate Calendar fields, There's more…
- dimensional value
- latest record read, identifying with Previous() function / Using the Previous() function to identify the latest record read for a dimensional value, There's more…
- dimensionless bar charts
- creating, in Qlik Sense® / Creating dimensionless bar charts in Qlik Sense®, There's more…
- disable
- visual-data preparation, using / There's more…
- distinct clause
- working with / Working with the distinct clause, Getting ready, There's more…
- distribution analysis / Distribution, How it works…
- dual() function
- used, for setting sort order of dimensions / Using the dual() function to set the sort order of dimensions, How it works…
- dynamic charts
- creating / Creating dynamic charts, There's more…
E
- Edit mode
- Master Library, using / Using a master library in Edit mode
- element functions E()
- using, in Set analysis / Using the element functions P() and E() in Set Analysis, There's more…
- element functions P()
- using, in Set Analysis / Using the element functions P() and E() in Set Analysis, There's more…
- embedded functions
- using, in Set Analysis / Using embedded functions in Set Analysis, How it works…
- embedded sheets
- adding, to story / Adding embedded sheets to the story, There's more…
- extended interval match
- used, for handling slowly changing dimensions / Using an extended interval match to handle slowly changing dimensions, How to do it…, There's more…
- extensions
- searching, on Qlik Branch / Finding extensions on Qlik Branch, There's more…
- importing, into Qlik Branch / How to import extensions (Desktop and Server), There's more…
F
- field values
- persistent colors, associating with script / Associating persistent colors to field values using the script, There's more…
- FirstSortedValue() function
- used, for identifying the median in quartile range / Using the FirstSortedValue() function to identify the median in a quartile range, How it works…
- following
- visual-data preparation, using / How it works…
- For each loop
- using, to load data from multiple files / Using a For each loop to load data from multiple files, There's more…
- used, for extracting files from folder / Using the For Each loop to extract files from a folder, How it works…
- Fractile() function
- used, for generating quartiles / Using the Fractile() function to generate quartiles, How it works...
- FTP server
- data, extracting / Extracting data from the FTP server, Getting ready, There's more…
I
- images
- creating / Creating text and images, How to do it…, How it works…
- intersection
- using, between sets for Basket Analysis / Using the intersection between sets for Basket Analysis, How it works…
K
- keyboard
- using, for navigate / Using the keyboard to navigate and interact, There's more…
- using, for interact / Using the keyboard to navigate and interact, There's more…
- Keyhole Markup Language (KML) / Creating geo maps in Qlik Sense®
- Key Performance Indicators (KPIs) / Highlighting the performance measure in a bar chart
- KPI object
- using, in Qlik Sense® / Effectively using the KPI object in Qlik Sense®, How it works…
L
- latest record read
- identifying, with Previous() function for dimensional value / Using the Previous() function to identify the latest record read for a dimensional value, There's more…
- Legacy Mode
- activating, in Qlik Sense® desktop / Activating the legacy mode in Qlik Sense® desktop, There's more…
- list of field values
- capturing, with Concat() function in Set Analysis / Capturing a list of field values using a Cconcat() function in Set Analysis, How to do it…
M
- Master Library
- creating, from Data model viewer / Creating a master library from the Data model viewer, How to do it…, There's more...
- using, in Edit mode / Using a master library in Edit mode, There's more…
- measure names
- using, in object expressions / Using measure names in object expressions, There's more…
- median
- identifying, in quartile range with FirstSortedValue() function / Using the FirstSortedValue() function to identify the median in a quartile range, How it works…
- Minstring() function
- used, for calculating age of oldest case in queue / Using the Minstring() function to calculate the age of the oldest case in a queue, How it works…
- moving annual total (MAT)
- multiple tabs
- working with / Working with multiple tabs, How to do it…, There's more…
N
- nested aggregations
- using / Using nested aggregations, How it works…
- NetworkDays() function
- used, for calculating working days in calendar month / Using the NetworkDays() function to calculate the working days in a calendar month, How it works…
O
- object expressions
- measure names, using / Using measure names in object expressions, There's more…
- Open Database Connectivity (ODBC) / Getting ready
P
- Peek() function
- used, for creating currency exchange rate calendar / Using the Peek() function to create a currency exchange rate calendar, How it works…
- used, for creating trial balance sheet / Using the Peek() function to create a trial balance sheet, How it works…
- performance measure
- highlighting, in bar chart / Highlighting the performance measure in a bar chart, How it works…
- persistent colors
- associating, to field values with script / Associating persistent colors to field values using the script, There's more…
- Previous() function
- used, for identifying latest record read for dimensional value / Using the Previous() function to identify the latest record read for a dimensional value, There's more…
- private sheets
Q
- Qlik Branch
- extensions, searching / Finding extensions on Qlik Branch, There's more…
- extensions, importing / How to import extensions (Desktop and Server), There's more…
- Qlik Management Console (QMC) / How to do it…
- Qlik Sense
- subroutines, using / How to use subroutines in Qlik Sense®, How it works…
- Qlik Sense®
- geo maps, creating / Creating geo maps in Qlik Sense®, There's more…
- KPI object, using / Effectively using the KPI object in Qlik Sense®, How it works…
- dimensionless bar charts, creating / Creating dimensionless bar charts in Qlik Sense®, There's more…
- Qlik Sense® application
- publishing, created in Qlik Sense® Desktop / Publishing a Qlik Sense® application created in Qlik Sense® Desktop
- publishing, to Qlik Sense® Cloud / Publishing a Qlik Sense® application to Qlik Sense® Cloud, How it works…
- Qlik Sense® desktop
- Legacy Mode, activating / Activating the legacy mode in Qlik Sense® desktop, There's more…
- QlikView Script File / Packaging the code in script files
- quartiles
- generating, with Fractile() function / Using the Fractile() function to generate quartiles, How it works...
R
- RangeSum() function
- using, to plot cumulative figures in trendline charts / Using the RangeSum() function to plot cumulative figures in trendline charts, How it works…
- Rank()
- using, with Aggr() / Using Rank() with Aggr, There's more…
- reload extension
- reload time of application
- optimizing / Optimizing the reload time of the application, How it works…
- REST Connector
- used, for extracting data from web services / Extracting data from web services with REST Connector, How it works…
S
- Sales reference lines
- versus Target gauge chart reference lines / Reference lines in a Sales versus Target gauge chart, There's more…
- scatter chart
- data points, navigating / Navigating many data points in a scatter chart, How it works…
- script
- used, for associating persistent colors to field values / Associating persistent colors to field values using the script, There's more…
- structuring / Structuring the script
- debugging, efficiently / Efficiently debugging the script, How to do it…, There's more…
- command line programs, executing / Executing command-line programs within the script, There's more…
- script files
- code, packaging / Packaging the code in script files, How it works…
- search strings
- using, inside set modifier / Using search strings inside a set modifier, How it works…
- Set Analysis
- syntax, cracking / Cracking the syntax for Set Analysis, How to do it…, There's more…
- flags, using / Using flags in Set Analysis, How to do it…, There's more…
- = sign, using with variables / Using the = sign with variables in Set Analysis, How it works…
- used, for point in time / Point in Time using Set Analysis, How to do it…, How it works…
- comparison sets, using / Using comparison sets in Set Analysis, How it works…
- embedded functions, using / Using embedded functions in Set Analysis, How it works…
- multi-measure expression, creating / Creating a multi-measure expression in Set Analysis, How it works…
- list of field values, capturing with Concat() function / Capturing a list of field values using a Cconcat() function in Set Analysis, How to do it…
- element functions P(), using / Using the element functions P() and E() in Set Analysis, There's more…
- element functions E(), using / Using the element functions P() and E() in Set Analysis, There's more…
- combining, with Aggr() / Combining set analysis with Aggr, There's more…
- set modifier
- search strings, using / Using search strings inside a set modifier, How it works…
- ShowHide Container extension
- simple KPI extension
- single cell
- multiple field values, storing with CONCAT function / Using the Concat() function to store multiple field values in a single cell, There's more…
- slowly changing dimensions
- handling, with extended interval / Using an extended interval match to handle slowly changing dimensions, How to do it…, There's more…
- snapshots
- creating / Creating snapshots, There's more…
- sort order of dimensions
- setting, with dual() function / Using the dual() function to set the sort order of dimensions, How it works…
- standard deviation (SD)
- reference link / How it works…
- statistical data
- measuring, with box plot charts / Measuring statistical data with box plot charts, How it works…
- Statistical Process Control (SPC) chart / How it works…
- story
- content, creating / Creating and adding content to a story, How to do it…, There's more…
- content, adding / Creating and adding content to a story, How to do it…, There's more…
- embedded sheets, adding / Adding embedded sheets to the story, There's more…
- string of field values
- displaying, with Concat() function as dimension / Using the Concat() function to display a string of field values as a dimension, How it works…
- subfield() function
- used, for splitting field into multiple records / Using the subfield() function to split field into multiple records, How it works…
- subroutines
- using, in Qlik Sense / How to use subroutines in Qlik Sense®, How it works…
T
- Target gauge chart reference lines
- versus Sales reference lines / Reference lines in a Sales versus Target gauge chart, There's more…
- text
- creating / Creating text and images, How to do it…, How it works…
- thumbnails
- treemaps
- creating / Creating treemaps, There's more…
- trendline charts
- reference lines, adding / Adding reference lines to trendline charts, How it works…
- trial balance sheet
- creating, with Peek() function / Using the Peek() function to create a trial balance sheet, How it works…
U
- UI calculation speed
- optimizing / Optimizing the UI calculation speed, How it works…
V
- value comparison / Comparison, How it works…
- variable extension
- variables
- managing, in script / Managing variables in the script and layout, How to do it…, There's more…
- managing, in layout / Managing variables in the script and layout, There's more…
- managing, layout / How to do it…
- visual-data preparation
- using, on data-manager model viewer / Using visual data preparation on the data manager model viewer, How to do it…, How it works…, There's more…
- visual exploration menu
- visualizations
- structuring / Structuring visualizations, How it works…
W
- waterfall
- using, to analyze cumulative effect / Using a waterfall chart to analyze the cumulative effect, How it works…
- web files
- data, extracting / Extracting data from web files, How it works…
- web services
- data, extracting with REST Connector / Extracting data from web services with REST Connector, How it works…