Master Measures vs. One Pivot Table. Guess Who Won?

If Finance trusts Excel more than your Qlik app, this isn’t a modeling problem. It’s a reconciliation problem.

Author

Glenda Carnate
February 27, 2026

Read time: 2.5 minutes

The developer is confident that by presenting the right keys, no synthetic associations, correctly separated fact/dimension, and standard Master Measures, the results will be correct. The Qlik is a beautiful model.

Finances open Excel and load a pivot table. They apply filters.

Pause.

“The pivots aren’t matching my numbers.”

When this happens, architecture has no bearing... alignment holds. Development focuses on logical correctness, while Finance focuses on financial truth. If totals differ, there is no trust.

Reasons for this issue (and how to resolve it):

1. Set analysis in Qlik as opposed to implicit filtering in Excel: Recreate the logic used in Excel to provide the ability to compare the two side by side.

2. Excel has hidden filters (manual filters, slicers, excluded rows): Check and validate the raw number of rows before performing any total comparison.

3. Timing difference between retrieval of data in Excel and the last time the Qlik application was reloaded: Display the "Last reload date" prominently throughout the application.

4. Master measures in Qlik do not equal calculated fields in Excel: Create documentation for each measure in plain English.

5. Rounding and Sign Conventions: The finance people round numbers differently when providing information for reporting purposes, or they may reverse the sign in some cases.

Having a clean model does not guarantee you can make reliable comparisons... understanding how to compare the data through reconciliation will give you that confidence.

💡Key Takeaway: 

Dashboards provide structure; pivot tables provide verified information.

If your app in Qlik cannot be reconciled with an Excel export, it is not yet complete.

👉 LIKE this if you’ve ever heard someone say ‘it doesn’t match my pivot’.

👉 SUBSCRIBE now for how-to tutorials on data modeling techniques and ways to build trust with stakeholders through using BI.

👉 Follow Glenda Carnate for practical breakdowns on data modeling and stakeholder trust.

👉 COMMENT with your most challenging reconciliation debate.

👉 SHARE this with someone who still trusts their Excel workbooks more than your dashboard.

Reply

or to participate.