Qlik Sense Cookbook
This course has been retired. Check out the alternatives below
-
What do you get with a Packt Subscription?
- Instant access to this title and 7,500+ eBooks & Videos
- Constantly updated with 100+ new titles each month
- Breadth and depth in over 1,000+ technologies
-
Getting Started with the Data
- Getting Started with the Data
- Introduction
- Extracting data from databases and data files
- Extracting data from Web Files
- Activating the Legacy Mode in Qlik Sense desktop
- Extracting data from custom databases
- Invoking help while in the data load editor or the expression editor
- Previewing data in the Data model viewer
- Creating a Master Library from the Data model viewer
- Using a Master Library in the Edit mode
-
Visualizations
- Visualizations
- Introduction
- Creating Snapshots
- Creating and adding content to a story
- Adding embedded sheets to the story
- Highlighting the performance measure in a bar chart
- Associating persistent colors to field values
- Using the ColorMix1 function
- Composition
- Relationships
- Comparison
- Distribution
- Structuring visualizations
-
Scripting
- Scripting
- Introduction
- Structuring the script
- Efficiently debugging the script
- Packaging the code in script files
- How to use sub routines in Qlik Sense
- Optimizing the UI calculation speed
- Optimizing the reload time of the application
- Using a For Each loop to load data from multiple files
- Using the Concat function to store multiple field values in a single cell
-
Managing Apps and User Interface
- Managing Apps and User Interface
- Introduction
- Publishing a Qlik Sense application created in Qlik Sense desktop
- Creating private, approved, and community sheets
- Publishing a Qlik Sense application to Qlik Sense cloud
- Creating geo maps in Qlik Sense
- Reference lines in Sales versus Target gauge chart
- Effectively using the KPI object in Qlik Sense
- Creating Tree Maps
- Creating dimensionless bar charts in Qlik Sense
- Adding Reference Lines to trendline charts
- Creating text and images
- Applying limitations to charts
- Adding thumbnails – a clear environment
- Navigating many data points in a scatter chart
-
Useful Functions
- Useful Functions
- Introduction
- Using an extended interval match to handle Slowly Changing Dimensions
- Using the Previous() function to identify the latest record for a dimensional value
- Using the NetworkDays() function to calculate the working days in a calendar month
- Using the Concat() function to display a string of field values as a dimension
- Using the Minstring() function to calculate the age of the oldest case in a queue
- Using the Rangesum() function to plot cumulative figures in trendline charts
- Using the Fractile() function to generate quartiles
- Using the FirstSortedValue() function to identify the median in a quartile range
- Using the Declare and Derive functions to generate Calendar fields
- Setting up a moving annual total figure
- Using the For Each loop to extract files from a folder
- Using the Peek() function to create a currency Exchange Rate Calendar
- Using the Peek() function to create a Trial Balance sheet
-
Set Analysis
- Set Analysis
- Introduction
- Cracking the syntax for Set Analysis
- Using flags in Set Analysis
- Using the = sign with variables in Set Analysis
- Point in time using Set Analysis
- Using comparison sets in Set Analysis
- Using embedded functions in Set Analysis
- Creating a multi-measure expression in Set Analysis
- Using search strings inside a set modifier
- Capturing a list of field values using a concat() function in Set Analysis
- Using the element functions P() and E() in Set Analysis
-
Extensions in Qlik Sense
- Extensions in Qlik Sense
- Introduction
- Creating an HTML visualization extension for Qlik Sense
- Defining a Properties panel in Qlik Sense visualizations
- Creating custom components within Qlik Sense visualizations
- Using data with extensions
-
What's New in Version 2.1.1?
- What's New in Version 2.1.1?
- Introduction
- Using the visual exploration capability in Qlik Sense 2.1.1
- Defining variables in Qlik Sense
- Exporting stories to MS PowerPoint
- Using the Qlik Dev Hub in Qlik Sense 2.1.1
- Using Extension editor in Qlik Dev Hub
- Using Qlik Dev Hub to generate mashups
- Embedding Qlik Sense application on a website using a single configurator
- Using the Qlik DataMarket
- Creating dynamic charts in Qlik Sense
- Using Smart Search
- Using smart data load profiling
- Conclusion