QlikSense Visualizations Masterclass

Explore smart search in Qlik Sense using free-form queries and expression search across an associative data model. Apply five selection states to filter decades, directors, ratings, lengths, and actor collaborations.

Explore smart search, a google-like tool that returns text and charts from free-form queries, then filter by decade and rating to reveal Vertigo (1958) by Alfred Hitchcock.

Explore the basics of data types—nominal, ordinal, and interval/ratio—and match visuals to each: nominal with pie or bar charts, ordinal with bars, and interval/ratio with scatter or box plots.

Build a data model in Qlik Sense with data manager to load QVD sources, establish associations via common keys, forming a star schema around a fact table and dimensions.

Learn how QlikSense auto generates the data load script from the data manager and inspect a star schema with key fields, information density, and subset ratio as data quality indicators.

Explore dimensions and measures for creating charts, and learn how master items—predefined libraries of dimensions, measures, and visualizations—speed up design in the QlikSense visualizations masterclass.

Master items define and reuse dimensions and measures, such as country, customer, month, product category, year, quarter, salesperson, and sales, cogs, margin, margin percent, orders, and discount.

Create an executive dashboard in Qlik Sense by building bar and line charts linked to master items, enabling drill-down from KPI views to detailed analytics with a combo chart.

Create two master items—month year dimension and average deal size measure from online sales divided by orders—and build a combo chart to plot orders and deal size.

Learn to build a donut pie chart in QlikSense that shows sales by country as a composition of total sales, using top five and others.

Show how to create a box plot by country across quarters to display median sales, quartiles, whiskers, and outliers, revealing distribution and skew, in the QlikSense visualizations masterclass.

Create a KPI object in the QlikSense dashboard to display sales as a single numeric value, with margin shown as a related KPI.

Add a second KPI using the margin master item and apply conditional colors. Set thresholds at 250k and 500k to show red, orange, or green, updating the dashboard with selections.

Create a customer pivot table in QlikSense, adding customer and country, with sales, profit margin, and last order date, format numbers, remove nulls and zeros, and highlight margins below 55%.

Create a master item to compute current year to date minus last year to date sales with an if statement, then visualize a color by measure customer bar chart.

Create a comparative analysis in QlikSense by building master item for current year to date minus last year to date sales, then display a customer bar chart with value labels.

Use the filter pan to control data shown in visualizations by selecting year, quarter, month, country, and customer. This self-service feature updates all visuals on the sheet.

Use the class function to bin catalog price into price groups and build a master item for the product analysis sheet and apply the price group dimension across charts.

Build a master item with the class function, then create a pivot table to analyze product category, name, price, group catalog, orders, and sales, using replace to format price group.

Master the pivot table using a master item price group and replace function to format price ranges, then add category, product, catalog price, sales, number of orders, and margin percent.

Replace bar chart with line chart in the QlikSense Visualizations Masterclass, set dimension to month, show data points and value labels, exclude null values, and display monthly sales.

Create a scatter plot of price vs sales, with bubble size by orders, showing how price impacts sales and how order volume varies.

Create a scatter plot chart with product name as the dimension, catalog price as the measure, and number of orders as bubble size to show price versus sales.

Explore how expressions power dynamic labels, texts, colors, and kpis in qliksense visualizations. Leverage current year to date and last year to date flags for year-over-year insights.

Learn to color and sort chart values in QlikSense using expressions, highlighting margins below 50% and ordering by sum of line sales amount.

Apply an average discount expression and an if-statement-driven background color expression to highlight discounts over 7% in light gray, while sorting sales by the customer field from highest to lowest.

Build an average discount measure, format as percent, color values above 7% light gray and others dark gray, and sort by sum of line sales amount descending by customer name.

Build a gauge chart on the dashboard that shows current year-to-date orders versus last year-to-date orders, with a dynamic title computed by an expression.

Create and apply a color variable in QlikSense to ensure color consistency across treemap and scatter plots using dollar sign expansion of the variable expression.

Create a treemap chart on the product sheet and apply a color expression using dollar sign expansion to build a silent legend using a color variable for category name.

Learn set analysis fundamentals in Qlik Sense, including identifiers, modifiers, and operators to build powerful, filtered aggregations with curly braces and angle brackets.

Master comparative analysis for year over year KPI insights by using set analysis and dollar sign expansion to compute current year and previous year sales, then visualize the difference.

Learn how the aggr function creates an in-memory virtual table to enable nested inner and outer aggregations, with set analysis integration.

FirstSortedValue returns the associated dimension based on a sort-weighted range in script and chart, defaulting to the lowest value and allowing a minus sign to show the highest.

Use Aggr in Qlik Sense to compute the highest selling product category and present a dynamic label with first sorted value, ignoring selections for an accurate key performance indicator.

Create a table with country, product name, and sales, then display the lowest selling product amount and its name in a text object using aggr() and sorted value.

Learn how to save regular selections as bookmarks and craft and share data stories in QlikSense using snapshots, text objects, and comments to drive insight driven decisions.

Build a predictive model in QlikSense with simple linear regression, using a scatter plot of poverty percent vs teen pregnancy rate and built-in coefficient of correlation and coefficient of determination.

Explore subset ratio in data modeling and apply associative insight to identify customers who did not place orders, revealing excluded values and guiding sales insights.

Learn to use nested parameterized variables in QlikSense visualizations, with button actions that set a days variable (30, 60, 90) and drive dynamic KPI labels and colors.

Explore the August 22 release's new set analysis syntax in QlikSense Visualizations Masterclass, externalizing set modifiers to reuse base expressions and master items with clear inheritance rules.