21 March 2022 Qlik Sum() function TOTAL qualifier Share this message Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about the use of the TOTAL qualifier within the sum() function. We’re a bit short-handed this week, so we’re keeping this week’s answer brief. The key to getting this question right is being aware of the TOTAL qualifier and the option to add one or more chart dimensions between angle brackets. The correct answer is D: Sum(Sales) / Sum(TOTAL <Model> Sales) By itself, the TOTAL qualifier will return the total Sales for the entire table. When you add chart dimensions between angle brackets, it will return the total Sales for that dimension. For example, Sum(TOTAL <Model> Sales) returns the total Sales for the dimension Model, ignoring Size. That’s it, see you next Friday! More from the Bitmetric team Bitmetric Qlik Support Keep your Qlik environment running smoothly with proactive support that prevents issues before they appear. Available on flexible monthly plans. Learn more. Qlik vs Power BI Series See how Qlik and Power BI perform when theory meets reality. Three apps rebuilt, every step examined. Learn more. Expressions Friday Qlik Test Prep Solution How can we help? Whether something’s still unclear or you’re ready to take the next step, Barry and Eric are happy to talk it through. Email us, call us, or book a meeting at a time that works for you. Call us Mail us 1 September 2026 Qlik Answers review: What we learned from real-world testing We tested Qlik Answers on a real production sales model to see how it handles real-world analytics. The results were promising, but getting reliable answers required careful work on the logical model, master measures, dimensions and business context. AI Data Analysis Qlik Semantic Layer 25 August 2026 Your semantic layer is becoming the API for AI Semantic layers are not new, but AI is giving them a new role. Where they once primarily powered dashboards, semantic models are increasingly becoming the layer that provides AI with reliable business context. AI Data Governance Microsoft Fabric Qlik Semantic Layer TimeXtender 17 August 2026 Putting AI to work on your data works. But not like this. Putting AI to work on your data sounds simple. But what can we learn from organizations already doing it? Based on Anthropic’s experience and independent research: what works, what doesn’t, and why maintenance is where the real work lies. AI Data Governance Data Management Power BI Qlik
1 September 2026 Qlik Answers review: What we learned from real-world testing We tested Qlik Answers on a real production sales model to see how it handles real-world analytics. The results were promising, but getting reliable answers required careful work on the logical model, master measures, dimensions and business context. AI Data Analysis Qlik Semantic Layer
25 August 2026 Your semantic layer is becoming the API for AI Semantic layers are not new, but AI is giving them a new role. Where they once primarily powered dashboards, semantic models are increasingly becoming the layer that provides AI with reliable business context. AI Data Governance Microsoft Fabric Qlik Semantic Layer TimeXtender
17 August 2026 Putting AI to work on your data works. But not like this. Putting AI to work on your data sounds simple. But what can we learn from organizations already doing it? Based on Anthropic’s experience and independent research: what works, what doesn’t, and why maintenance is where the real work lies. AI Data Governance Data Management Power BI Qlik