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 6 November 2026 Qlik Cloud overage: who decides how much risk you face? A small error in Qlik Cloud can lead to unexpected overage charges. But how large can that financial risk become? We share our own experience, explain how Data for Analysis overage works, and discuss why customers should be able to decide how much additional capacity they want to allow. We also look at ways to prevent overages and at developments surrounding Usage Bank. Data Analysis Governance Qlik 6 November 2026 Microsoft Fabric and Power BI: The Most Important Updates from October 2026 AI agents that build Power BI reports, independently perform data engineering, and provide increasingly accurate answers to questions about business data. In October, Microsoft once again made significant progress with Fabric and Power BI. But what do these developments mean in practice? We discuss the most important updates and share our experiences and insights. Agentic […] Microsoft Fabric New Release Power BI 4 November 2026 Qlik Cloud Update October 2026: Semantic Models, AI, and Modern Development October brought 24 updates to Qlik Cloud. The introduction of Semantic Models in Data Products stands out in particular. Qlik Code for VS Code, AI-assisted development, and improvements to the Direct Access gateway also deserve attention. Our consultants discuss what these developments mean in practice. New Release Qlik
6 November 2026 Qlik Cloud overage: who decides how much risk you face? A small error in Qlik Cloud can lead to unexpected overage charges. But how large can that financial risk become? We share our own experience, explain how Data for Analysis overage works, and discuss why customers should be able to decide how much additional capacity they want to allow. We also look at ways to prevent overages and at developments surrounding Usage Bank. Data Analysis Governance Qlik
6 November 2026 Microsoft Fabric and Power BI: The Most Important Updates from October 2026 AI agents that build Power BI reports, independently perform data engineering, and provide increasingly accurate answers to questions about business data. In October, Microsoft once again made significant progress with Fabric and Power BI. But what do these developments mean in practice? We discuss the most important updates and share our experiences and insights. Agentic […] Microsoft Fabric New Release Power BI
4 November 2026 Qlik Cloud Update October 2026: Semantic Models, AI, and Modern Development October brought 24 updates to Qlik Cloud. The introduction of Semantic Models in Data Products stands out in particular. Qlik Code for VS Code, AI-assisted development, and improvements to the Direct Access gateway also deserve attention. Our consultants discuss what these developments mean in practice. New Release Qlik