Examice

Exam QSBA2018 All QuestionsBrowse all questions from this exam

Question 12

A business analyst needs to create an app showing sales data. The app requirements are as follows:

✑ Compare sales for the current year (CY Sales) versus last year (LY Sales)

✑ CY Sales must always be displayed in blue

✑ LY Sales must always be displayed in yellow

Which steps should the business analyst take to meet these requirements?

1. Create a KPI with two measures, CY Sales and LY Sales 2. Write an IF expression to set the appropriate colors for each measure

1. Create CY Sales and LY Sales measures as master items 2. Write an IF expression to set the appropriate colors for the master items

1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures

1. Create CY Sales and LY Sales measures as master items and set the required color for each measure using Value colors 2. Create two gauges, one for each measure and set the color for each appropriately

Correct Answer: C

To meet the requirements of displaying CY Sales in blue and LY Sales in yellow consistently, the best approach is to create the CY Sales and LY Sales measures as master items and set the required color for each measure directly within the master item properties. This ensures that the colors are always correctly assigned regardless of where the measures are used. After setting the colors, the analyst should create a single KPI using these master item measures, which allows for a streamlined and reusable approach that adheres to the specifications.

Discussion

ELIKAINEOption: C

C. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures

peachmanOption: C

A) This will work, however its not recommended as it doesn't use Master Measures B) This solved the problem of A not using a master measure, but this still uses an IF for the colour C) Correct answer - Create aa master measure and sets the color of the measure within the GUI and uses a KPI to display the results D) D is incorrect as it implies the colours are set on the gauge object itself not via the master measure that is re-useable.

elipsaOption: C

C. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures In KPI we can show 2 measures value

val38Option: C

C. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures

vickyzzOption: C

On Qlik site: The correct answer is: 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures