In this scenario, the second measure (Count of MajorCities) is likely not being displayed because the two measures—Sum(Knowing sections)andCount(MajorCities)—are on vastly different scales. When two measures have significantly different ranges, one of them may not be visible on the same Y-axis, causing the issue you're seeing where no bars are visible for the second measure.
By converting the bar chart to acombo chart, the business analyst can display both measures with appropriate configurations. The combo chart allows you to display different measures in different ways, such as using one axis for the first measure (e.g., bars forSum(Knowing sections)) and another axis for the second measure (e.g., bars forCount(MajorCities)), ensuring that both are visible on the chart.
Key Concepts:
Combo Chart: This type of chart allows you to display multiple measures using different axis scales or types of visualization (e.g., bars and lines).
Scale Mismatch: When two measures differ significantly in scale, they may not be displayed properly on the same axis. A combo chart helps by allowing separate Y-axes for each measure.
Why the Other Options Are Less Suitable:
A. Enable Value labels: While value labels can help show specific data points, they won't resolve the issue of one measure being invisible due to scale differences.
B. Recreate as an alternative measure: This would allow switching between measures, but the requirement is to show both measures simultaneously.
C. Change Y-axis Range to Custom: While adjusting the Y-axis manually might help, it’s not the best solution because the scale difference between the two measures might still cause issues, and it would be harder to adjust dynamically.
References for Qlik Sense Business Analyst:
Combo Charts for Multiple Measures: Combo charts are recommended in Qlik Sense when you need to display multiple measures with different scales.
Thus, converting the bar chart to acombo chartensures both measures are properly displayed, makingDthe correct answer.
