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?
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.
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
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
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
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
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.