Bitmetric Friday Qlik Test Prep – Week 11 – Sum(TOTAL) – Solution

By Bitmetric Admin


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:

No alt text provided for this image

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!

Want to participate?

We’re having lots of fun coming up with these questions here at Bitmetric. Perhaps some of you would like to join in the fun?

We’re always looking for new colleagues, but we understand that you might be looking for participation with a little less up-front commitment 😉

If you have suggestions for good questions, feel free to send them to us via WhatsApp or by getting in touch via [email protected].

Previous posts

Week 10: Unpivoting data

Week 9: Statements & Breakpoints

Week 8: Sales & Budget model

Week 7: MonthEnd(Today())

Week 6: Looping Tables

Week 5: Set Identifiers

Week 4: Time series visualization

Week 3: Circular References & Synthetic Keys

Week 2: Section Access

Week 1: Optimized Load

About The Author

Bitmetric Admin

Blog posts from the Bitmetric team. At Bitmetric, Qlik is what we do. We've been doing it for years, and we can do it for you! ;)

Leave a Reply

Your email address will not be published. Required fields are marked *

Read previous post:
Reminder: PinIt webinar on March 17th

With PinIt for Qlik Sense, you can get a personalized, one-page overview across all Qlik Sense dashboards in your environment....

Close