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
  • using / Using alternate states, How to do it…, There's more...
• approved sheets
  • creating / Creating private, approved, and community sheets, There's more...

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
  • using / Using the colormix1 function, How it works…
• command line programs
  • executing, within script / Executing command-line programs within the script, There's more…
• community sheets
  • creating / Creating private, approved, and community sheets, There's more...
• 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)
  • about / Setting up a moving annual total figure, How it works…
  • setting up / Setting up a moving annual total figure, How it works…
• 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
  • creating / Creating private, approved, and community sheets, There's more...

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
  • using / Using the Reload button extension, There's more…
• 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
  • using / Using the ShowHide Container extension, How to do it…, There's more…
• simple KPI extension
  • using / Using the simple KPI extension, How it works…
• 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
  • adding / Adding thumbnails to a clear environment, How it works…
• 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
  • using / Using the Variable extension, How to do it…
• 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
  • using / Using the visual exploration menu, There's more…
• 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…