QlikSense Visualizations Masterclass

Discover the Qlik Sense hub architecture, from data access to presentation. See how apps use sheets, bookmarks, and stories built on a star schema data model.

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.

Solve the challenge by using expression search to locate Alfred Hitchcock's highest-rated 1950 film with a rating of five.

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.

Convert the bar chart to a combo chart with a month-year dimension, using two axes to show orders as bars and average deal size as a line.

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.

Add a text object to display margin percent as a KPI in your QlikSense dashboard, formatting it as a percent with one decimal and labeling it 'margin percent' for clarity.

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 scatter plot chart to show sales vs. discount for each customer. Use bubble size for orders and color by measure, with three measures in view.

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.

Explore treemap charts to visualize hierarchical relationships among dimensions, such as price group, category name, and product name, with rectangle size indicating quantity.

Replace the bar chart with a line chart using month and sales, set the presentation style to area map, show data points, and color by measure.

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.

Create a silent color legend by defining a category name color expression and applying it via dollar sign expansion, ensuring consistent colors across treemap and scatter plots.

Apply calculation conditions to prevent chart recalculation for large data sets, recalculating only when the count of company name is less than ten and showing a friendly prompt otherwise.

Learn to build current year to date sales by multiplying the line sales amount with the current year to date flag to create a simple aggregation.

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

Apply set analysis to fix current year to date sales by using a current year to date flag and an identifier that ignores user selections, preserving the CYTD value.

Calculate the current year-to-date margin with set analysis using a modifier, filtering on year-to-date flag equals 1, and use braces, angle brackets, and an identifier to ignore selections.

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 FirstSortedValue() with aggr() to identify the top salesperson for 1998 by aggregating sales amount across product name, category name, and salesperson, using set analysis to show the highest value.

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.

Learn how the total qualifier redefines a chart's aggregation scope by ignoring dimensions and use angle brackets to preserve the country dimension for the highest selling product by country.

Identify the highest selling category by country using a measure based on sales amount and the total qualifier to ignore other dimensions, with the country specified in the angle bracket.

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.

Create a table with country, product, and sales; use aggr to form a table by country and product, wrap in min to show the lowest sales in a text object.

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 aggregation functions and their optional rank parameter to display top country values by revenue in a multi kpi using parameterized expressions and dynamic labels.

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.

Discover practical tips for building Qlik Sense mashups: locate object IDs via developer options, reference objects in JavaScript, create a basic template, and use a Chrome plugin to view IDs.

Explore cyclic dimensions in a QlikSense mashup and dynamically switch a line chart's dimension between year and month using the Capability API and apply patches.

Learn to reuse master items in Qlik Sense by creating variables for sales and margin and using dollar sign expansion to form a new margin percent measure.

Learn to build drill-down maps in QlikSense by configuring country and city dimensions, adjusting area and point layers, and using wild match to focus on United States.

learn to create a slope graph in Qlik Sense using set analysis to compare margin changes by country across years, with color cues and filter panes for year and country.

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.

Discover how to create custom charts in Qlik Sense with the Picasso visualization library, building a butterfly chart using components, a legend, and a titled visualization.

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.