Qlik Sense System Administrator Certification (2024) — Question 2

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?

Answer options

• A. CY Revenue, LY Revenue, CY Cost
• B. CY Revenue, LY Revenue, Cost
• C. Revenue and Cost
• D. Revenue and CY Cost

Correct answer: A

Explanation

The correct answer is A because it includes CY Revenue and LY Revenue, which are essential for the KPI comparison, along with CY Cost, which is necessary for the cost-related table. Options B, C, and D are inadequate as they either lack CY Cost or do not include both CY and LY Revenue needed for the KPI indicator.