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? Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have. Call us Mail us 27 May 2026 What should be included in a good Qlik Cloud backup? A good Qlik Cloud backup is more than exporting apps. Here is what you actually want to protect, and why thinking about restore deserves more attention than it usually gets. Governance Qlik Support 31 March 2026 A Beginner’s Guide to Microsoft Fabric Microsoft Fabric is not just another tool. It is Microsoft’s attempt to bring data engineering, data integration, analytics, and business intelligence into one unified platform. Microsoft Fabric 30 October 2025 Provisioning 100+ Qlik Cloud tenants on an OEM subscription Automating the provisioning of 100+ Qlik Cloud tenants using Qlik CLI and an OEM subscription. Lessons learned, practical tips, and reflections from the Masters Summit for Qlik. Automation Governance Masters Summit No-Code Qlik Training
27 May 2026 What should be included in a good Qlik Cloud backup? A good Qlik Cloud backup is more than exporting apps. Here is what you actually want to protect, and why thinking about restore deserves more attention than it usually gets. Governance Qlik Support
31 March 2026 A Beginner’s Guide to Microsoft Fabric Microsoft Fabric is not just another tool. It is Microsoft’s attempt to bring data engineering, data integration, analytics, and business intelligence into one unified platform. Microsoft Fabric
30 October 2025 Provisioning 100+ Qlik Cloud tenants on an OEM subscription Automating the provisioning of 100+ Qlik Cloud tenants using Qlik CLI and an OEM subscription. Lessons learned, practical tips, and reflections from the Masters Summit for Qlik. Automation Governance Masters Summit No-Code Qlik Training