Welcome to ONLC Training Centers

Qlik Sense Advanced Course

Class Dates
(click date for class times)
(click Enroll for locations)
4/17-4/18
Class Dates and Times
04/17/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/18/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!

  

Register Soon!
Registrations on or after Friday 4/11 incur a late registration charge to cover book shipping and provisioning costs.
Before 4/11$895
On/After 4/11$985
Last Reg Date4/14
 
5/12-5/13
Class Dates and Times
05/12/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/13/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
6/12-6/13
Class Dates and Times
06/12/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
06/13/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
7/7-7/8
Class Dates and Times
07/07/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
07/08/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
Fee:  $895

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


Qlik Sense Advanced Course

 

Overview

This class is an excellent course for all aspiring Qlik Sense® developers. It will take you through the basics, right through to the use of more advanced functions.

Starting with a quick refresher on obtaining data from data files and databases, this class moves on to the more refined features of Qlik Sense®, including visualization, scripting, and set analysis. The tips and tricks provided will help you to overcome challenging situations while developing your applications in Qlik Sense®. This and more will help you to deliver engaging dashboards and reports efficiently.

Prerequisites

Before attending this course, students should attend Qlik Sense Introduction class or have equivalent experience.

COURSE OUTLINE

Unit 1: Getting Started with the Data

  • Extracting data from databases and data files
  • Extracting data from Web Files
  • 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

Unit 2: Visualizations

  • Highlighting the performance measure in a bar chart
  • Associating persistent colors to field values
  • Using the ColorMix1 function
  • Composition
  • Relationships
  • Comparison
  • Distribution
  • Structuring visualizations

Unit 3: Scripting

  • Structuring the script
  • Efficiently debugging the script
  • Packaging the code in script files
  • Optimizing the UI calculation speed
  • Using a For Each loop to load data from multiple files
  • Using the Concat() function to store multiple field values in a single cell

Unit 4: Managing Apps and User Interface

  • Publishing a Qlik Sense® application created in Qlik Sense® desktop
  • Creating geo maps in Qlik Sense
  • Reference lines in Sales versus Target gauge chart
  • Effectively using the KPI object in Qlik Sense
  • Adding Reference Lines to trendline charts
  • Creating text and images

Unit 5: Useful Functions

  • 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 Rangesum() function to plot cumulative figures in trendline charts
  • Using the Declare and Derive functions to generate Calendar fields
  • Using the For Each loop to extract files from a folder

Unit 6: Set Analysis

  • Cracking the syntax for Set Analysis
  • Using flags in Set Analysis
  • Using the = sign with variables in Set Analysis
  • Using comparison sets in Set Analysis
  • Using search strings inside a set modifier

Unit 7: Extensions in Qlik Sense®

  • Creating an HTML visualization extension for Qlik Sense®
  • Defining a Properties panel in Qlik Sense visualizations
  • Creating custom components within Qlik Sense visualizations

Unit 8: What's New

  • Defining variables in Qlik Sense
  • Exporting stories to MS PowerPoint
  • Using Qlik Dev Hub to generate mashups
  • Embedding Qlik Sense application on a website using a single configurator
  • Creating dynamic charts in Qlik Sense

 

View outline in Word

XQSM30

Attend hands-on, instructor-led Qlik Sense Advanced training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment


ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect