Qlik Sum() function TOTAL qualifier

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.