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 Qlik Cloud Backup Protect your investment in Qlik with daily incremental backups stored in an encrypted environment with redundant storage. Available for as little as 2 Euro per day. Learn more. Masters Summit for Qlik The Masters Summit for Qlik provides the next step in your path to becoming a Qlik specialist. As an extra perk, Bitmetric has secured an over $450 discount just for you! Use code BITMETRIC at checkout. Read more here. 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 13 June 2025 Qlik Extension: Scroll to Object Ever since Qlik introduced extended sheets in June 2018, we at Bitmetric have been fans. The ability to extend a sheet vertically and add visualizations below the fold is a powerful way to present more insights without cluttering the main view. Yet, even after seven years, it still feels like a hidden feature. Many users […] Extension Qlik 2 June 2025 Simplifying Data Integration with TimeXtender At Bitmetric, we believe in making technology work for people, not the other way around. TimeXtender’s approach to data integration fits this philosophy by removing obstacles and giving users practical tools to manage their data. Solution TimeXtender 12 May 2025 Dagelijkse Qlik Ondersteuning: altijd hulp bij data analyse Bij Bitmetric snappen we hoe belangrijk het is dat je Qlik omgeving gewoon goed werkt. Of je nu dagelijks data analyseert of snel wat inzichten nodig hebt, je wilt dat alles soepel verloopt. Daarom staan onze experts elke dag voor je klaar. Van kleine vragen tot ingewikkelde uitdagingen, we helpen je graag verder, zodat jij je kunt focussen op wat echt telt! Qlik
13 June 2025 Qlik Extension: Scroll to Object Ever since Qlik introduced extended sheets in June 2018, we at Bitmetric have been fans. The ability to extend a sheet vertically and add visualizations below the fold is a powerful way to present more insights without cluttering the main view. Yet, even after seven years, it still feels like a hidden feature. Many users […] Extension Qlik
2 June 2025 Simplifying Data Integration with TimeXtender At Bitmetric, we believe in making technology work for people, not the other way around. TimeXtender’s approach to data integration fits this philosophy by removing obstacles and giving users practical tools to manage their data. Solution TimeXtender
12 May 2025 Dagelijkse Qlik Ondersteuning: altijd hulp bij data analyse Bij Bitmetric snappen we hoe belangrijk het is dat je Qlik omgeving gewoon goed werkt. Of je nu dagelijks data analyseert of snel wat inzichten nodig hebt, je wilt dat alles soepel verloopt. Daarom staan onze experts elke dag voor je klaar. Van kleine vragen tot ingewikkelde uitdagingen, we helpen je graag verder, zodat jij je kunt focussen op wat echt telt! Qlik