Exam QSBA2018 topic 1 question 12 discussion

Actual exam question from QlikView's QSBA2018

Question #: 12
Topic #: 1

[All QSBA2018 Questions]

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?

A. 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
B. 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
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
D. 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

Show Suggested Answer

Suggested Answer: C 🗳️

by vickyzz at Jan. 28, 2023, 11:28 a.m.

Comments

Submit Cancel

peachman

1 year, 12 months ago

Selected Answer: 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.

upvoted 1 times

...

elipsa

2 years, 2 months ago

Selected Answer: 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

upvoted 1 times

...

val38

2 years, 4 months ago

Selected Answer: 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

upvoted 1 times

...

ELIKAINE

2 years, 5 months ago

Selected Answer: 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

upvoted 2 times

...

vickyzz

2 years, 5 months ago

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

upvoted 1 times

...