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.

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.

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.

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.

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.

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 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.

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.

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.

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.