• The Data Mix
  • Posts
  • 📊 The Master Sword of Qlik? It’s hiding in plain sight.

📊 The Master Sword of Qlik? It’s hiding in plain sight.

In partnership with

Hey, it’s Brian again 👋

Last week’s issue - 📊 Why load it all when 2% is all you need?” - broke down ODAG and why trying to load everything into one Qlik app can lead to misery.

If you missed it, give it a read - especially if your apps are starting to feel more like data swamps than dashboards.

This week, we’re starting something new.

It’s Part 1 of a two-part deep dive into Master Items - your go-to tools for clarity, consistency, and build speed inside Qlik.

And because structure and story go hand-in-hand, I’m bringing a bit of Zelda energy into the mix.

Think: raw fields as your wooden sword... and Master Items as the upgrade that changes the game.

Whether you’re a solo dev or managing a whole reporting estate, these are the tools that help you move faster and build better.

And if you’re working on something similar right now - a new app, a complex KPI layer, or a reporting strategy that needs refining - I’d love to hear about it.

Let’s dive in.

In Today’s Issue

I’m going to cover these things with you today!

  1. But First - A request for your support - Have Qlik requirements? Drop me a line.

  2. Cool Tool - The Rundown AI - Learn how to use AI in just 5 minutes a day.

  3. But First (2)…Qlik at the Databricks Data + AI Summit - Databricks' Data + AI Summit is live in San Francisco this week.

  4. Cool Tool (2) - Air Landline - A smarter, more professional way to take business calls.

  5. Deep Dive - The Overworld of Master Items - A hands-on guide to Master Dimensions and Measures.

  6. Before You Go - Other ways that I can help and work with you

Finally - at the end of my newsletter, you’ll get a poll to tell me how I did and feedback what you’d like to see in the future and do for YOU! Let’s hope it’s not a 🥧 chart!

First time reading? ⏬⏬

But First…I need your help 🙏

Quick note before we dive into today’s issue 👇

I’m now looking for my next Qlik contract with immediate availability.

So if you’ve been:
→ Wrestling with reporting chaos
→ Exploring a new Qlik Cloud rollout
→ Wondering how WhatsApp for Qlik could work in your business
→ Or just need a second pair of eyes on your dashboards or automation setup…

I would really appreciate hearing from you!

Whether it’s advisory, hands-on development, or something experimental – I’d love to hear what you’re working on.

🫵 Drop me a quick message on WhatsApp: +44 131 560 6887 or just reply to this email.

Your support means a lot - thank you!

⚒️ Cool Tool - The Rundown AI

Learn AI in 5 minutes a day

This is the easiest way for a busy person wanting to learn AI in as little time as possible:

  1. Sign up for The Rundown AI newsletter

  2. They send you 5-minute email updates on the latest AI news and how to use it

  3. You learn how to become 2x more productive by leveraging AI

But First (2)…Qlik at the Databricks Data + AI Summit!

Databricks' Data + AI Summit is live in San Francisco this week, and Qlik just dropped something worth paying attention to.

They've expanded their Databricks integration with a clear focus on real-time, AI-ready pipelines. A few key highlights jumped out:

  • Streaming ingestion into Unity Catalog Iceberg tables using change data capture

  • Automatic optimization for Apache Iceberg via Qlik Open Lakehouse

  • Cleaner, governed inputs for Mosaic AI and other large-scale workloads

  • And coming soon - Spark-native features like schema inference, debugging, and notebook import

It’s all in private preview for now, but the direction is obvious - more Databricks-native tooling, better governance, and faster time to AI.

If you’re at the summit, booth 521 is where Qlik’s showing it off, or watch the livestream below.

⚒️ Cool Tool (2) - Air Landline

As a freelancer or small business owner, first impressions matter - especially when it comes to how clients contact you. But let’s be honest, most of us are using our personal mobile number to handle work calls. It’s not ideal.

What if there was a way to instantly look more professional - without buying a second phone, juggling SIMs, or dealing with complicated call apps?

That’s where Air Landline comes in.

What is Air Landline?
Air Landline gives you a virtual UK landline number that rings directly to your mobile. No apps. No hardware. Just a smart, professional way to take business calls and separate them from personal life.

Why It’s a Game-Changer:

  • You look instantly more established with a landline number

  • Keep your personal number private

  • Works with WhatsApp Business

  • Call recording and voicemail included

  • No contracts. Cancel anytime.

Real-Life Use Case:
I started using Air Landline after one too many client calls interrupted my weekend. Now, I have a separate line with voicemail and custom call routing. It’s made my solo biz feel 10x more legit.

Final Thoughts:
For under £10/month, it’s honestly one of the smartest upgrades I’ve made to my freelance setup.

⚔️ The Master Plan (Part 1): Entering the Overworld of Master Items in Qlik Sense

You start your journey in Qlik like most adventurers do - raw fields in hand, building visuals one chart at a time.

It works. It gets the job done.

But everything feels… manual. A little fragile.

Then, one day, you find it.

A single item - glowing quietly in the Assets panel.

"Add to Master Items."

And just like that, your build process changes.

From here on out, your expressions are reusable. Your dimensions, governed. Your charts, consistent and clean.

You didn’t just organize your app. You drew the Master Sword.

Welcome to the Overworld

Before we head into the deeper dungeons of formatting strategy and dashboard governance, we need to understand the lay of the land.

This first part of our Master Items deep dive is your Overworld map - a guide to the essential tools you'll be using again and again: Master Dimensions and Master Measures.

These are the early-game power-ups. They don’t just help you fight off inconsistencies and duplication - they change how you build.

And yes, it really is that big of a shift.

What Are Master Items, Really?

At their core, Master Items in Qlik Sense are reusable definitions. They let you create a central list of dimensions, measures, and visualizations that you can reference throughout your app.

Instead of rewriting the same expression ten different ways, or dragging a raw field into a chart and formatting it manually every time, you create a Master Item once.

From then on, it’s just drag, drop, done.

There are three main types:

  • Master Dimensions (single fields, calculated dimensions, or drill-downs)

  • Master Measures (expressions, often aggregations)

  • Master Visualizations (complete charts, covered in Part 2)

But in this phase of the journey, it’s all about the core items: dimensions and measures. Think of them as your sword and shield. Your build fundamentals.

Why Use Them? (Spoiler: They're Not Just for Developers)

Let’s address the obvious question: why bother?

If you’ve ever had to manually update a KPI expression across five different charts because the logic changed, you already know the pain.

✅ Master Items solve that.

If you’ve had a stakeholder ask why a measure looks different between two sheets, only to discover one uses a raw field and the other a slightly tweaked formula...

✅ Master Items solve that too.

If you're building governed self-service dashboards and you want business users to explore without wrecking the underlying logic...

✅ You guessed it: Master Items.

Here’s what they unlock:

  • Consistency: Define once, reuse everywhere

  • Governance: Lock in naming, descriptions, formatting, and colors

  • Speed: No more re-writing expressions or hunting through charts

  • Clarity: Replace technical field names with business-friendly labels

  • Maintainability: Update logic in one place and it propagates automatically

And just like the Master Sword, once you start using them, it becomes hard to imagine building without them.

Master Dimensions: From Raw Fields to Reusable Building Blocks

A Master Dimension is any field (or calculated field) you want to standardize across your app.

🔑 Key Use Cases:

  • Renaming technical fields for clarity

  • Enabling drill-down dimensions (e.g. Region → Country → City)

  • Defining label expressions that change dynamically

  • Applying consistent colors to dimension values

    Setting the Dimension Value colour in Master Dimensions

One of the best features here is drill-downs, and here’s the kicker: you can’t build drill-down hierarchies unless you create them as Master Dimensions.

So if you want users to be able to click into charts and progressively zoom from Year → Month → Date, Master Items aren’t optional — they’re required.

🛡️ Master Dimension Tips:

  • Use readable names ("Customer Name" instead of "cust_nm")

  • Add descriptions to guide end users

  • Tag them with synonyms (Insight Advisor will thank you)

  • Set colors for values when relevant (especially for maps and KPIs)

  • Always check the label expression - it’s now respected properly in the selection bar (a long-awaited fix!)

Master Dimension name always visible in the selections bar.

Yes, that last one is worth repeating:

There was an issue where Qlik would show the raw field name in the selection bar instead of the master dimension label.


That’s now fixed. Master Item labels are now always shown.

Master Measures: Lock In Your Logic

This is where the real power starts to show.

Master Measures allow you to define expressions (e.g. Sum(Sales), Avg(Margin), Count(Distinct CustomerID)) once and reuse them everywhere.

You can also:

  • Set number formatting (money, percent, custom)

  • Assign a default color (great for consistent UI themes)

  • Define segment colors (e.g. red for negative growth, green for positive)

  • Add descriptions, tags, and even use them inside other expressions

🧠 Why They Matter:

  • They reduce errors (especially in complex set analysis)

  • They centralize your KPIs (no more formula drift)

  • They make onboarding easier (new developers can explore your Master Items to understand key metrics)

Think of your Master Measures as enchanted scrolls.

You write the logic once, imbue it with context, formatting, and metadata - and then anyone who drags it into a chart wields it exactly as intended.

🧩 What About Variables?

Variables are useful, but they serve a different purpose.

Variables let you define a piece of logic that can be reused across multiple expressions using the $(VariableName) syntax. This is great for things like currency conversion rates, thresholds, or base conditions.

But here’s where Master Measures have an advantage:

  • Variables are invisible to end users. Master Measures are visible, selectable, and tagged.

  • Variables don’t carry formatting. Master Measures can define number formats, colors, and segment rules.

  • Variables are more flexible. They’re ideal when you want dynamic logic that users can input or change.

  • Master Measures are more governed. They’re the right choice when you need consistency and UI integration.

In many apps, the two work together: use variables inside Master Measures when you need reusable parameters. But expose your key metrics as Master Measures so they show up cleanly and consistently across the UI.

Field vs. Master: Why Bother?

"Why not just use the field?"

Sometimes, you can. Not every field needs to be a Master Item.

But if you care about naming, formatting, descriptions, governance, reuse, or enabling users to build charts safely...

You want to use Master Items.

Here’s a quick comparison:

Raw Field

Master Dimension

Display Name

Field name

Business-friendly label

Description

None

Optional & helpful

Colors

Manual per chart

Set once, used everywhere

Drill-down?

Not supported

Fully supported

Tags

Not available

Yes (for search & AI)

In short: raw fields are fine for exploration. Master Dimensions are for real builds.

Coming Up in Part 2: Into the Dungeon

Master Dimensions and Measures are your core kit.

But you haven’t explored the full map yet.

In Part 2, we will descend into the dungeon:

  • Master Visualizations

  • Maintenance and refactoring

  • Formatting tips for color, number, and label control

  • Advanced governance patterns

  • Tips for handling large libraries and multi-app ecosystems

We’ll also talk about how to build your Master Item library so it scales with you - whether you're a solo dev or a whole team of analysts.

Until then, check your inventory.

You might already be holding the Master Sword.

You just haven’t swung it yet.

Before you go - here’s 3 ways I can help you

  1. LinkedIn - I’m always talking about Data, Qlik on there and would love to connect with you!

  2. WhatsApp for Qlik - Want to talk to your data in Qlik using WhatsApp? I built that as a service and you can check out the demo.

  3. The Data Mix Podcast on YouTube - Every fortnight, I deliver a cordial interview with the best guests in the world of Data and Analytics.

P.S. If you’re interested in sponsoring the newsletter, please drop me a reply and let me know. Let’s talk!

Reply

or to participate.