Qlik Sense System Administrator Certification (2024) — Question 7

The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category.
The sales manager wants to have the potential percentage Sales for each Stage (Initial to Won) of the sales process.
Which visualizations will meet these requirements?

Answer options

• A. Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
• B. Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales
• C. Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales
• D. Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

Correct answer: B

Explanation

Answer B is correct because it provides a scatter plot to explore the linear relationship between Sales and Margin with the appropriate dimensions, and a funnel chart to visualize the Sales percentages across different Stages. The other options either do not effectively analyze the relationship or do not provide the necessary visualizations for the sales process stages.