Qlik Sense Business Analyst Free Sample Questions

A financial services firm needs to create a risk exposure dashboard. A key requirement is to color-code a scatter plot of investments based on a calculated Risk Score, where scores below 20 are green, 20-50 are yellow, and above 50 are red. The Risk Score is already calculated as a measure. Which expression, used in the object's color properties, is the most efficient way to implement this requirement?

A supply chain analyst is building an application to monitor inventory levels. The primary data table contains ProductID, WarehouseID, TransactionDate, and Quantity. The analyst needs to create a master measure that calculates the 'Stock on Hand' for any given date selection. This requires summing all quantities for transactions up to and including the maximum selected date. Which set analysis expression correctly calculates this running total?

A business analyst at an e-commerce company is creating a dashboard. They need to display the top 5 customers by sales, but also include an 'Others' category that aggregates the sales for all remaining customers. How can this be achieved within a single bar chart dimension?

A business analyst has loaded two tables, Sales and Sales_Targets, into the Data Manager. Both tables contain a Region and a Quarter field (e.g., 'Q1 2024'). To analyze performance against targets, these tables must be associated. However, the business analyst wants to avoid a synthetic key on Region and Quarter. What is the recommended approach in the Data load editor to create a robust, single-field key for this association?

During a requirements gathering session for a new human resources dashboard, the HR Director states, 'I need to see the employee headcount trend over the last 3 years, but I also need to be able to see the distribution of employees by age bracket and tenure at any point in time. It must be clear how our demographics are shifting.' Which combination of visualizations would best fulfill all aspects of this request? (Select TWO)

True or False: When using Data Manager to associate two tables, if Qlik Sense provides a recommendation with a high confidence score, the analyst should always apply it without further investigation to ensure model efficiency.

An analyst is building an app for the sales team. A requirement is to show the sales performance of each salesperson relative to the average sales of their specific region. Which function should be used to achieve this comparison within a chart expression?

A business analyst is designing a dashboard for executives. The primary goal is to provide a high-level overview of company performance on a single screen, with the ability to understand the status of key metrics at a glance. The design should follow the DAR (Dashboard, Analysis, Reporting) methodology. Which sheet design principle is most appropriate for this initial dashboard sheet?

A marketing analyst needs to create a story to present campaign results. The presentation must include a slide showing the state of the app when the 'Email' campaign is selected, and another slide showing the state when the 'Social Media' campaign is selected. However, the analyst also needs one slide with a live, interactive chart where they can make selections during the presentation. How should the analyst construct this story?

A business analyst is profiling a newly loaded Customers table. In a filter pane for the PostalCode field, the analyst notices that some codes are formatted as five-digit numbers (e.g., 90210) while others are strings (e.g., 'SW1A 0AA'). This data quality issue is causing incorrect associations and sorting problems. What is the most appropriate place to standardize the PostalCode field to a text format for all records?