Which action should the business analyst take?

A business analyst needs to create two side-by-side charts for a sales department with the following data:

• Number of orders

• Name of the customer

• Percentage of margin

• Total sales

The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values.

Which action should the business analyst take?

A. Use nested IF statements to set the colors by expression for each dimension value

B. Define the color values in the master measures and use the color library

C. Select ‘By Dimension’ and ‘Persistent colors’ in the Colors property panel

D. Use the Fieldlndex function to set the colors by expression for each dimension value

View Answer

Answer: C

Explanation:

In Qlik Sense, the ‘By Dimension’ and ‘Persistent colors’ options in the Colors property panel ensure that the same dimension values have the same color across multiple charts. This is especially useful when you have two or more side-by-side charts sharing a common dimension, like customer names in this case. Persistent colors guarantee consistency in color assignment, helping users visually track the same dimension across different visualizations. Key Concepts:

By Dimension: This option ensures that each unique value of a dimension (e.g., customer name) gets a distinct color across all charts that use this setting.

Persistent Colors: This feature ensures that the colors remain the same between charts, making the visual comparison across charts easier for the users.

Why the Other Options Are Less Suitable:

A. Use nested IF statements to set the colors by expression for each dimension value: While this would work, it would be unnecessarily complex to maintain and manage, especially with many dimension values.

B. Define the color values in the master measures and use the color library: This would only apply if the goal was to set colors based on measures, not dimensions. In this case, dimension consistency is

required, not measure-based coloring.

D. Use the FieldIndex function to set the colors by expression for each dimension value: This would involve writing complex expressions that would not be as straightforward as using the built-in functionality of ‘By Dimension’ and ‘Persistent colors’. References for Qlik Sense Business Analyst:

Color Consistency Across Charts: The ‘By Dimension’ and ‘Persistent colors’ settings are recommended in Qlik Sense documentation when creating multi-chart layouts with shared dimensions, ensuring visual coherence across different charts.

The Persistent colors and By Dimension settings offer a straightforward and maintainable way to create color associations across charts, making option C the verified solution.