QlikView QSBA2024 Practice Exams
Last updated on Apr 07,2025- Exam Code: QSBA2024
- Exam Name: Qlik Sense Business Analyst Certification Exam - 2024
- Certification Provider: QlikView
- Latest update: Apr 07,2025
A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control.
The visualization has several requirements:
• Starts with the top five products
• Allows the user to change the number of products displayed
• Allows the user to scroll through all products on a mini chart
The business analyst creates a bar chat and a variable.
Which steps should the business analyst complete next?
- A . • Add the slider object and use the variable to set its value
• Set the number of bars to custom and use the variable to set its value - B . • Use the variable to fix the limitation
• Add an input box to enable the user to enter the required value - C . • Use the variable to fix the limitation
• Add a slider object and use the variable to set its value - D . • Add the slider object and use the variable to set its value
• Use the properties to set the number of bars to custom
Refer to the exhibit.
The users of a Qlik Sense app report slow performance. The app contains approximately 10 million rows of data.
The business analyst notices the following KPI master measure definition:
Left{ Trim( TransactionName), 1 ) * Right ( TransactionName, 5) Which steps should the business analyst complete to improve app performance?
- A . Ask the developer of the underlying database to change the structure of the field
TransactionName. - B . • In the Data manager, use the Split function to split the field values with the underscore character as the separator.
• In the Data manager, use the Add calculated field function to multiply the 1st and the 3rd column of the split field.
• Reload the data. - C . Change the master measure definition as follows:
subfield( TransactionName, ”,!)* subfieldl TransactionName, ‘ ‘, 3) - D . In the Data manager, use the Replace function to remove the middle part of the field TransactionName
A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.
Which step should the business analyst complete next?
- A . Define a variable and use it in a variable input object on the sheet
- B . Create a calculated field in Data manager, using the Class() function
- C . Load an independent source file to contain the user-defined boundary values
- D . Create the price range dimension using the Buckets feature in Data manager
A dashboard developer finishes creating a supply chain analysis app and is presenting it to leadership for review.
The landing page shows four visualizations including:
• Bar chart showing available supply by product category
• Line chart showing total cost of deliveries to the warehouse by month-year
• Scatter plot showing cost of delivery and time-to-deliver by product
• A map that shows the volume of delivery from suppliers to warehouses using a line layer Leadership asks the developer how they can see the total cost of delivery overall.
How can the analyst show this information to leadership?
- A . Use the line chart to add up each month-year to get to the number required
- B . Create a KPI object that shows the total cost of delivery
- C . Adjust the line layer on the map to reflect cost of delivery
- D . Select all products in the scatter plot to see the total delivery cost
An app needs to load a few hundred rows of data from a .csv text file. The file is the result of a concatenated data dump by multiple divisions across several countries. These divisions use different internal systems and processes, which causes country names to appear differently. For example, the United States of America appears in several places as ‘USA’, ‘U.S.A.’, or ‘US’.
For the country dimension to work properly in the app, the naming of countries must be standardized in the data model.
Which action should the business analyst complete to address this issue?
- A . Create a calculated master dimension expression
- B . Load a lookup table to convert values
- C . Cleanse the source text file prior to loading
- D . Use the Replace option in Data manager
A company has recently implemented Qlik Sense. A user is looking to use natural language questions to help create content.
Which feature can achieve this goal?
- A . Advanced Authoring
- B . Story and Bookmarks
- C . Insights Advisor Chat
- D . Associative Engine
A project management team uses an app to monitor different projects.
• Projects may have co-dependent tasks and processes
• Some projects include subtasks
The business analyst needs to use a diagram similar to a workflow with the processes and the sub tasks represented as boxes with lines to relate them to each other. The color of the boxes could also be determined by the status of each project or task.
Which visualization should be used?
- A . Sankey chart
- B . Grid chart
- C . Org chart
- D . Network chart
A customer is developing over 100 apps, each with several sheets that contain multiple visualizations and text objects. The customer wants to standardize all colors used every object across every app. The customer also needs to be able to change these colors quickly, as required.
Which steps should the business analyst take to make sure the color palette is easily maintained in every app?
- A . • Design all base objects as master visualizations
• Link each object in each app to the relevant master visualization
• Adjust the data properties as required - B . • Develop the first app with every variation of object and visualization that will be required
• Duplicate this app to create every other app
• Remove the variations that are not required and adjust the ones needed - C . • Create all color expressions as variables in a text file
• Load it in each app with an include statement
• Use these variables in the color property of all objects - D . • Store color definitions within a .qvd file
• Have each app load this file as a data island in the model
• Have every object select its required color property from the rows within the data island
A business analyst is creating a new app with sales data.
The visualizations must meet several requirements:
A Bar chart that shows sales by product group is used in multiple sheets
• A KPI object that visualizes that the total amount of sales is used once
• A Treemap that shows margin by product group is used one time inside a Container
Which visualization should be added to the master items library?
- A . Container
- B . KPI
- C . Bar chart
- D . Treemap
A business analyst is developing an app that contains a data model with fields: Country, City, Sales, ProductName, and ProductCategory. The global sales manager wants to add new visualizations to this app.
The business analyst must include the following:
• Ability to dynamically change the number of countries and cities
• Display a maximum of 10 countries
• Display a maximum of 5 cities per country
Which steps should the business analyst take?
- A . • Create two variables: vCountry and vCity
• Add a slider for vCountry and vCity max limit range
• Apply the variable to each visualization - B . • Add an input field for vCountry and vCity
• Set the dimension limitation to the required maximum values: 5 and 10
• Apply the variable to each visualization
• Add a bookmark Country and City - C . • Add an input field for vCountry and vCity
• Set the dimension limitation to the required maximum values: 5 and 10
• Apply the variable to each visualization - D . • Create two variables: vCountry and vCity
• Add a slider for vCountry and vCity
• Apply the variable to each visualization
• Set a sheet action that limits the data displayed