Home Big-data-and-business-intelligence Qlik Sense Cookbook

Qlik Sense Cookbook

4.2 (10 reviews total)
By Philip Hand , Neeraj Kharpate
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
Access now Or Sign In
  1. 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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?
    • 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
Qlik Sense Cookbook
Unlock this book and the full library FREE for 7 days
Start now