In addition to the customer satisfaction rating, which fields should be used to create the required measures?

A banking organization needs a dashboard that shows the following:

• A KPI indicator for current year (CY) versus last year (LY) revenue

• A scatter plot that shows the cost versus revenue of product categories

• A treemap that shows average customer satisfaction rating based on regions

• A table that shows CY cost by record number, financial instrument, and bank

In addition to the customer satisfaction rating, which fields should be used to create the required measures?
A . CY Revenue, LY Revenue, CY Cost
B . CY Revenue, LY Revenue, Cost
C . Revenue and Cost
D . Revenue and CY Cost

View Answer

Answer: A

Explanation:

The banking dashboard requires several KPIs and visualizations based on current year (CY) and last year (LY) revenue, as well as cost and customer satisfaction. To build the required measures, the fields CY Revenue, LY Revenue, and CY Cost are necessary because they provide the comparison between the current and previous year, as well as cost-related data for the specific calculations. Key Concepts:

KPI for CY vs LY Revenue: This requires both CY Revenue and LY Revenue fields.

Scatter Plot for Cost vs Revenue: This comparison requires both CY Revenue and CY Cost to create the necessary relationship in the scatter plot.

Treemap for Customer Satisfaction: In addition to the customer satisfaction rating, the field CY Revenue would likely be used for additional insights by region.

Table with CY Cost: The table requires CY Cost data along with other relevant fields like record number, financial instrument, and bank.

Why the Other Options Are Less Suitable:

B. CY Revenue, LY Revenue, Cost: While this covers the revenue fields, it does not specifically include CY Cost, which is needed for the table and scatter plot.

C. Revenue and Cost: This option is too general and does not distinguish between current year and last year revenue, which is essential for the KPI.

D. Revenue and CY Cost: This does not include LY Revenue, which is required for the KPI.

References for Qlik Sense Business Analyst:

Comparison Measures in Qlik Sense: In Qlik Sense, comparisons across time periods like CY and LY require specific fields to calculate accurate insights, and it’s essential to ensure the appropriate fields are included for each visualization.

Thus, A provides the correct set of fields for the required dashboard, making it the verified answer.