A business analyst is creating an app using a dataset from ServiceNow.

To efficiently categorize support cases based on age (New, Aging, Beyond SLA) for use in multiple places across the dashboard, theBucket option in the Data Manageris the most efficient approach. Bucketing allows the business analyst to create new categories based on the values in an existing field (in this case, the age of support cases). Since the dataset is expected to grow, creating the categories directly within Qlik Sense ensures that the process is scalable without the need for external tools or extensive coding.

Key Concepts:

Bucket Function: This allows you to group numeric fields into predefined ranges or categories. The function is highly scalable, making it suitable for large datasets.

Efficiency: Creating a new field using Bucketing ensures that the categorization is done directly in the app, avoiding the need for external data sources or nested IF statements, which could impact performance.

Why the Other Options Are Less Suitable:

A. Ask the ServiceNow team to create the field: This would create a dependency on external teams and could delay the development process.

B. Create an Excel sheet: This adds unnecessary complexity and isn’t scalable as the dataset grows.

D. Write a master dimension with a nested IF statement: While this could work, it's less efficient for handling large datasets and could result in slower performance.

References for Qlik Sense Business Analyst:

Bucketing Data: Qlik Sense recommends using the Bucketing feature for creating predefined ranges or categories, especially when dealing with large datasets.

Thus, using theBucket optionto create a new field for categories is the most efficient solution, makingCthe correct answer.