Qlik Sense For Everyone

Explore the conceptual theory of set analysis in Qlik Sense with practical examples, learning to write set expressions using 1 identifier, dollar, and modifiers to control aggregations.

Set up a KPI object to show total sales for the corporate and consumer segments using set analysis, sum(sales), dollar sign, and angle brackets, with category and segment filters.

Create a pivot table showing total sales by consumer segment and technology category for each year, using ship year from ship date and a set analysis expression.

Create a key performance indicator object showing total sales for the corporate segment with ship year 2015 using set analysis, and ignore other selections.

Create a KPI object for total profit in furniture or office supplies in the west region for June 2016 using set analysis modifiers.

Explore set analysis in Qlik Sense by building a KPI that counts distinct customers who bought Sony products in 2016 and 2017, using curly braces, dollar sign, and angle brackets.

Learn set analysis by building a kpi object to calculate total sales for specific home office products using set expressions, with bookmarks to simplify and reuse selections.

Master set analysis operators in Qlik Sense, including union, exclusion, complement, intersection, and symmetric difference, and build set expressions to calculate total sales across selections.

Visualize Samsung phone sales in Qlik Sense using set analysis to compute total profit across bar charts and a Samsung phones KPI, excluding headset and case products.

Explore set analysis with operators to calculate Apple profits in a bar chart for the sales year break, using curly brackets and angle brackets to create measures and a KPI.

Learn how to use set modifiers with assignment and implicit set operators to filter Samsung phone profits by year selections, including 2018 and 2016, in a KPI object.

Explore set modifiers and implicit set operators in Qlik Sense. Build a line chart to compare Samsung and Apple profits by year using master items and f(x) expressions.

Explore set analysis in qlik sense by building a kpi object that sums profit for the phones subcategory while excluding samsung and apple, using union and minus operators.

Learn to write advanced set analysis modifiers to create a KPI showing total profit in the phones subcategory and total sales in 2017 over 1000.

Practice advanced set analysis in Qlik Sense by building expressions to compute Apple sales in 2016 and Samsung profits in 2017 for Apple customers, then view results in a table.

Use set modifiers with implicit field definitions in Qlik Sense to compute Samsung customers' total profit across categories. Create a KPI with the P function to isolate Samsung buyers.

Create a kpi object showing total profit from Apple products sold to those who never bought Samsung. Use p and e functions to exclude Samsung buyers and intersect with Apple.

This lecture demonstrates building a set analysis expression to show Samsung customers in 2014 within the phones subcategory, and creating a brand dimension with wildmatch and if in Qlik Sense.

Learn how to define and use variables in Qlik Sense, including let and set statements, data load editor, and applying variables across expressions and objects.

Define variables and a KPI to count distinct customers who bought Samsung products in the selected year. Employ the next-year variable and Phones subcategory for the following year’s results.

Change visualization colors in Qlik Sense by applying custom colors, using color by expression and color mix functions, and assign colors to measures, dimensions, and background for a publish-ready dashboard.

Combine two tables in Qlik Sense using outer, left, right, and inner joins, and explore keep prefixes for efficient data modeling.

Master building a clean Qlik Sense data model by left keep sales data, qualify fields, avoid synthetic keys, concatenate tables, and ApplyMap to country names.