Qlik Sense System Administrator Certification (2018) — Question 27

A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups are created in the data manager, and the field is named
AgeGroup:
✑ Children: 16 years old and younger
✑ YoungAdult: 17 to 30 years old
✑ Adult: 31 years old and older
The business analyst will use an expression to set the colors for the bars:
If ([AgeGroup] = 'Children', Red(), If ([AgeGroup] = 'YoungAdult', Blue(), Green()))
Which steps must be completed to apply the correct colors in the visualization?

Answer options

• A. Select Data in the properties panel and create a calculated dimension using the expression editor.
• B. Create a master item dimension using the expression, in the visualization, select Color by dimension and use the newly created master item.
• C. Under Appearance in the properties panel, select Color, then select Color by expression, and make sure that The expression is a color code is checked.
• D. Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.

Correct answer: C

Explanation

The correct answer is C because it directly involves setting the color for the bars based on the expression provided. Options A and B do not specifically address coloring the bars, and option D incorrectly suggests using a measure instead of an expression for color coding.