Qlik Sense System Administrator Certification (2018) — Question 7

A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month.
The business analyst creates a bar chart with the measure, Sum(Revenue).
Which final step should the business analyst take to complete the chart?

Answer options

• A. Add Region, Product Category, and Month as three different dimensions
• B. Create a single master dimension with Region, Product Category, and Month
• C. Add Region as a dimension, add Product Category and Month as alternate dimensions
• D. Create a cyclic group with Region, Product Category, and Month as dimensions

Correct answer: C

Explanation

The correct answer is C because adding Region as a dimension while treating Product Category and Month as alternate dimensions allows for effective visualization of the data in the bar chart. Options A and B do not align with the requirement for alternate dimensions, and D would complicate the chart unnecessarily as a cyclic group is not needed for this scenario.