Index
A
- age of oldest case, in queue
- calculating, Minstring() function used / Using the Minstring() function to calculate the age of the oldest case in a queue, How to do it…, How it works…
- approved sheets
- about / Creating private, approved, and community sheets
- creating / Getting ready, How it works…
B
- Bookmarks / How it works…
C
- Calendar fields
- generating, Declare function used / Using the Declare and Derive functions to generate Calendar fields, How to do it…, There's more…
- generating, Derive function used / Using the Declare and Derive functions to generate Calendar fields, How to do it…, There's more…
- Capventis Redmond Pie-Gauge
- reference link / There's more…
- charts
- limitations, applying to / Applying limitations to charts, How to do it…, There's more…
- code
- packaging, in script files / Packaging the code in script files, How to do it…, How it works…
- ColorMix1 function
- community sheets
- about / Creating private, approved, and community sheets
- creating / Getting ready, How it works…
- comparison
- about / Comparison, How it works…
- comparison sets
- using, in Set Analysis / Using comparison sets in Set Analysis, How to do it…, How it works…
- composition
- about / Composition, How to do it…, There's more…
- concat()
- used, for capturing list of field values / Capturing a list of field values using a concat() function in Set Analysis, How it works…
- Concat() function
- used, for displaying string of field values as dimensions / Using the Concat() function to display a string of field values as a dimension, How to do it…, How it works…
- Concat function
- for storing multiple field values in single cell / Using the Concat function to store multiple field values in a single cell, How it works…
- about / Using the Concat function to store multiple field values in a single cell
- contents
- creating / Creating and adding content to a story
- adding, to story / Creating and adding content to a story, How to do it…, There's more…
- cumulative figures, in trendlines charts
- plotting, Rangesum() function used / Using the Rangesum() function to plot cumulative figures in trendline charts, How to do it…, How it works…
- currency Exchange Rate Calendar
- creating, Peek() function used / Using the Peek() function to create a currency Exchange Rate Calendar, How to do it…, How it works…
- custom components
- creating, within Qlik Sense visualizations / Creating custom components within Qlik Sense® visualizations, Getting ready, How to do it…
- reference link, for creating / There's more…
D
- Dashboard Analysis Reporting (DAR) methodology / Introduction
- data
- about / Introduction
- extracting, from databases and 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 to do it…, How it works…
- extracting, from custom databases / Extracting data from custom databases, How to do it…, How it works…
- using, with extensions / Using data with extensions, How to do it…, How it works…
- data load editor
- data model viewer
- data, previewing / Previewing data in the Data model viewer, How it works...
- data model, viewing / Viewing the data model
- associations, viewing / Viewing the associations
- table meta data / Table Meta Data
- master library, creating from / Creating a Master Library from the Data model viewer, How to do it..., How it works..., There's more…
- data points
- navigating, in scatter chart / Navigating many data points in a scatter chart, How to do it…, How it works…
- Declare function
- used, for generating Calendar fields / Using the Declare and Derive functions to generate Calendar fields, How to do it…, There's more…
- Derive function
- used, for generating Calendar fields / Using the Declare and Derive functions to generate Calendar fields, How to do it…, There's more…
- dimensionless bar charts
- creating, in Qlik Sense / Creating dimensionless bar charts in Qlik Sense®, How to do it…, There's more…
- distribution
- about / Distribution, How to do it…
- dynamic charts
- creating, in Qlik Sense / Creating dynamic charts in Qlik Sense®, How to do it…, How it works…
E
- E() function
- using, in Set Analysis / Using the element functions P() and E() in Set Analysis, How to do it…, There's more…
- embedded functions
- using, in Set Analysis / Using embedded functions in Set Analysis, How it works…, There's more…
- embedded sheets
- adding, to story / Adding embedded sheets to the story, How to do it…, There's more…
- expression editor
- extended interval match
- used, for handling Slowly Changing Dimensions / Using an extended interval match to handle Slowly Changing Dimensions, How to do it…, How it works…, There's more…
- Extension editor
- using, in Qlik Dev Hub / Using Extension editor in Qlik Dev Hub, How to do it…, There's more…
- extensions
- data, using with / Using data with extensions, How to do it…, How it works…
F
- field values list
- capturing, concat() used / Capturing a list of field values using a concat() function in Set Analysis, How it works…
- files
- extracting from folders, For Each loop used / Using the For Each loop to extract files from a folder, Getting ready, How to do it…, How it works…
- files, Qlik Sense extension
- FirstSortedValue() function
- used, for identifying median in quartile range / Using the FirstSortedValue() function to identify the median in a quartile range, How it works…
- flags
- using, in Set Analysis expressions / How to do it…, There's more…
- For Each loop
- for loading data, from multiple files / Using a For Each loop to load data from multiple files, How to do it…, How it works…
- used, for extracting files from folders / Using the For Each loop to extract files from a folder, Getting ready, How to do it…, How it works…
- Fractile() function
- used, for generating quartiles / Using the Fractile() function to generate quartiles, How to do it…, How it works…
G
- geo maps
- creating, in Qlik Sense / Creating geo maps in Qlik Sense®, Getting ready, How to do it…, How it works…, There's more…
H
- HTML visualization extension
- creating, for Qlik Sense / Creating an HTML visualization extension for Qlik Sense®, How to do it…, How it works…, There's more…
- HyperCube
- about / How it works…
I
- Image
- creating / Creating text and images, Adding Images
K
- keyboard shortcuts, Qlik Sense Desktop
- 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 to do it…, How it works…, There's more…
L
- latest record, for dimensional value
- identifying, Previous() function used / Using the Previous() function to identify the latest record for a dimensional value, How it works…
- limitations
- applying, to charts / Applying limitations to charts, How to do it…, There's more…
- line-level table / Using the Concat() function to display a string of field values as a dimension
M
- maps generation, Qlik Sense
- URL / There's more…
- mashups
- generating, Qlik Dev Hub used / Using Qlik Dev Hub to generate mashups, How to do it…, How it works…, There's more…
- master library
- creating, from data model viewer / Creating a Master Library from the Data model viewer, How to do it..., How it works..., There's more…
- using, in edit mode / Using a Master Library in the Edit mode, How to do it...
- median, in quartile range
- identifying, FirstSortedValue() function used / 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 to do it…, How it works…
- moving annual total (MAT)
- about / Setting up a moving annual total figure
- reference link / Setting up a moving annual total figure
- moving annual total figure
- setting up / Getting ready, How to do it…, How it works…
- MS PowerPoint
- stories, exporting to / Exporting stories to MS PowerPoint, How to do it…, How it works…
- multi measure expression
- creating, in Set Analysis / Creating a multi-measure expression in Set Analysis, How to do it…, How it works…
N
- NetworkDays() function
- used, for calculating working days in calendar month / Using the NetworkDays() function to calculate the working days in a calendar month, How to do it…, How it works…
O
- Open Database Connectivity (ODBC) / Getting ready…
P
- P() function
- using, in Set Analysis / Using the element functions P() and E() in Set Analysis, How to do it…, There's more…
- Peek() function
- used, for creating currency Exchange Rate Calendar / Using the Peek() function to create a currency Exchange Rate Calendar, How to do it…, How it works…
- used, for creating Trial Balance sheet / Using the Peek() function to create a Trial Balance sheet, How to do it…, How it works…
- performance measure
- highlighting, in bar chart / Highlighting the performance measure in a bar chart, How to do it…, How it works…
- persistent colors
- associating, to field values / Associating persistent colors to field values, How to do it…, How it works…
- point in time analysis
- with sets / Point in time using Set Analysis, How to do it…, How it works…
- Previous() function
- used, for identifying latest record for dimensional value / Using the Previous() function to identify the latest record for a dimensional value, How it works…
- private sheets
- about / Creating private, approved, and community sheets
- creating / Getting ready, How it works…
- properties panel
- defining, in Qlik Sense visualizations / Defining a Properties panel in Qlik Sense® visualizations, How to do it…, How it works…
Q
- Qlik DataMarket
- Qlik Dev Hub
- about / Using the Qlik Dev Hub in Qlik Sense® 2.1.1
- using, in Qlik Sense 2.1.1 / Using the Qlik Dev Hub in Qlik Sense® 2.1.1
- single configurator / Single configurator, Single configurator
- extensions editor / Extensions editor, Extension editor
- mashup editor / Mashup editor
- working / How it works…
- Extension editor, using in / Using Extension editor in Qlik Dev Hub, How to do it…, There's more…
- used, for generating mashups / Using Qlik Dev Hub to generate mashups, How to do it…, How it works…, There's more…
- Qlik Sense
- about / Introduction
- geo maps, creating in / Creating geo maps in Qlik Sense®, Getting ready, How to do it…, How it works…, There's more…
- KPI object, using in / Effectively using the KPI object in Qlik Sense®, How to do it…, How it works…, There's more…
- dimensionless bar charts, creating in / Creating dimensionless bar charts in Qlik Sense®, How to do it…, There's more…
- HTML visualization extension, creating for / Creating an HTML visualization extension for Qlik Sense®, How to do it…, How it works…, There's more…
- variables, defining in / Defining variables in Qlik Sense®, How to do it…, How it works…, There's more…
- dynamic charts, using in / Creating dynamic charts in Qlik Sense®, How to do it…, How it works…
- QlikSense-Cookbook-C7-R1-HelloWorld.js
- Define / How it works…
- Paint / How it works…
- Qlik Sense 2.1.1
- visual exploration capability, using in / Using the visual exploration capability in Qlik Sense® 2.1.1, How it works…
- Qlik Dev Hub, using in / Using the Qlik Dev Hub in Qlik Sense® 2.1.1
- Qlik Sense application
- about / Introduction
- publishing, created in Qlik Sense desktop / Publishing a Qlik Sense® application created in Qlik Sense® desktop, How it works…
- publishing, to Qlik Sense Cloud / Publishing a Qlik Sense® application to Qlik Sense® cloud, How to do it…, How it works…, There's more…
- embedding, on website / Embedding Qlik Sense® application on a website using a single configurator, How to do it…, How it works…
- Qlik Sense Cloud
- Qlik Sense application, publishing to / Publishing a Qlik Sense® application to Qlik Sense® cloud, How to do it…, How it works…, There's more…
- Qlik Sense Cloud account
- URL / Getting ready
- Qlik Sense Desktop
- Legacy mode, activating / Activating the Legacy Mode in Qlik Sense® desktop, How to do it…, How it works…
- keyboard shortcuts / Keyboard shortcuts in Qlik Sense® Desktop
- Qlik Sense Installer file
- URL / Getting ready
- Qlik Sense script
- debugging efficiently / Efficiently debugging the script, How to do it…, How it works…
- Qlik Sense Server 2.1.1
- URL / Getting ready
- Qlik Sense visualizations
- properties panel, defining in / Defining a Properties panel in Qlik Sense® visualizations, How to do it…, How it works…
- custom components, creating within / Creating custom components within Qlik Sense® visualizations, Getting ready, How to do it…
- Qlikview / Getting ready…
- quartiles
- generating, Fractile() function used / Using the Fractile() function to generate quartiles, How to do it…, How it works…
- qvd file / How it works…
- QVS (QlikView Script File)
R
- Rangesum() function
- used, for plotting cumulative figures in trendlines charts / Using the Rangesum() function to plot cumulative figures in trendline charts, How to do it…, How it works…
- Reference Lines
- adding, to trendline charts / Adding Reference Lines to trendline charts, How to do it…, How it works…
- Reference Lines in Sales
- versus Target gauge chart / Reference lines in Sales versus Target gauge chart, How to do it…, There's more…
- relationships
- about / Relationships, How to do it…
- reload time, of application
- optimizing / Optimizing the reload time of the application, How it works…
S
- = sign
- using, with variables / Using the = sign with variables in Set Analysis, How to do it…, How it works…
- SAP connector / Getting ready…
- scatter chart
- data points, navigating in / Navigating many data points in a scatter chart, How to do it…, How it works…
- script
- structuring / Structuring the script, How to do it…, How it works…
- script files
- code, packaging / Packaging the code in script files, How to do it…, How it works…
- search strings
- using, inside set modifier / Using search strings inside a set modifier, How to do it…, How it works…
- Set Analysis
- about / Introduction, Cracking the syntax for Set Analysis
- syntax, cracking for / Cracking the syntax for Set Analysis, How to do it…, How it works…
- = sign, using with variables / Using the = sign with variables in Set Analysis, How to do it…, How it works…
- comparison sets, using in / Using comparison sets in Set Analysis, How to do it…, How it works…
- embedded functions, using in / Using embedded functions in Set Analysis, How it works…, There's more…
- multi measure expression, creating in / Creating a multi-measure expression in Set Analysis, How to do it…, How it works…
- P() function, using in / Using the element functions P() and E() in Set Analysis, How to do it…, There's more…
- E() function, using in / Using the element functions P() and E() in Set Analysis, How to do it…, There's more…
- Set Analysis expressions
- about / Using flags in Set Analysis
- flags, using in / How to do it…, There's more…
- set modifier
- about / There's more…
- search strings, using inside / Using search strings inside a set modifier, How to do it…, How it works…
- single configurator
- Qlik Sense application, embedding on website / Embedding Qlik Sense® application on a website using a single configurator, How to do it…, How it works…
- Slowly Changing Dimensions
- handling, extended interval match used / Using an extended interval match to handle Slowly Changing Dimensions, How to do it…, How it works…, There's more…
- smart data load profiling
- Smart Search
- using / Using Smart Search, How it works…, There's More….
- snapshots
- creating / Creating Snapshots, How to do it…, How it works…
- standard deviation
- reference link / How it works…
- Statistical Process Control (SPC)
- about / How it works…
- stories
- exporting, to MS PowerPoint / Exporting stories to MS PowerPoint, How to do it…, How it works…
- string of field values, as dimension
- displaying, Concat() function used / Using the Concat() function to display a string of field values as a dimension, How to do it…, How it works…
- sub routines
- using, in Qlik Sense / How to use sub routines in Qlik Sense®, How to do it…
- syntax
- cracking, for Set Analysis / Cracking the syntax for Set Analysis, How to do it…, How it works…
T
- Target gauge chart
- versus Reference Lines in Sales / Reference lines in Sales versus Target gauge chart, How to do it…, There's more…
- Text
- creating / Creating text and images, Getting ready, Adding Text, How it works…
- thumbnails
- tree maps
- about / Creating Tree Maps
- creating / Getting ready, How to do it…, How it works…, There's more…
- trendline charts
- Reference Lines, adding to / Adding Reference Lines to trendline charts, How to do it…, How it works…
- Trial Balance sheet
- creating, Peek() function used / Using the Peek() function to create a Trial Balance sheet, How to do it…, How it works…
U
- UI calculation speed
- optimizing / Optimizing the UI calculation speed, How to do it…
V
- variables
- = sign, using with / Using the = sign with variables in Set Analysis, How to do it…, How it works…
- defining, in Qlik Sense / Defining variables in Qlik Sense®, How to do it…, How it works…, There's more…
- visual exploration capability
- using, in Qlik Sense 2.1.1 / Using the visual exploration capability in Qlik Sense® 2.1.1, How it works…
- visualizations
- structuring / Structuring visualizations, How to do it…, How it works…
W
- website
- Qlik Sense application, embedding on / Embedding Qlik Sense® application on a website using a single configurator, How to do it…, How it works…
- working days, in calendar month
- calculating, NetworkDays() function used / Using the NetworkDays() function to calculate the working days in a calendar month, How to do it…, How it works…