Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Qlikview Discussions
exam questions

Exam QSBA2018 All Questions

View all questions & answers for the QSBA2018 exam
Go to Exam

Exam QSBA2018 topic 1 question 15 discussion

Actual exam question from QlikView's QSBA2018
Question #: 15
Topic #: 1
[All QSBA2018 Questions]


Refer to the exhibit.
A business analyst must analyze sales using an existing sales order app.
✑ The Orders table in the app was added from a QVD file using the data manager
✑ The Orders table in the app and the QVD do NOT contain a SalesAmount field
✑ SalesAmount can be calculated by multiplying the Quantity and UnitPrice
How should the business analyst add a SalesAmount field into the Orders table?

  • A. In the data manager, create a new calculated field, SalesAmount, and set the expression value to Sum(UnitPrice * Quantity)
  • B. In the data mode viewer, add a calculated field named SalesAmount with the expression UnitPrice * Quantity
  • C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity
  • D. In the Orders QVD file, add an additional field named SalesAmount with the expression UnitPrice * Quantity
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by elipsa at April 23, 2023, 5:12 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
peachman
1 year, 4 months ago
Selected Answer: C
A) Incorrect because you don't need the SUM() function as you are effecting line items from the QVD not aggregating. B) Incorrect because you can't add columns in the data model viewer page. C) Correct because you can use the data manger to add a new field D) Incorrect because you cant edit the QVD as you are a consumer of the QVD not the creator of it in this situation. this would be a valid solution however if you had access to the QVD builder script.
upvoted 1 times
...
elipsa
1 year, 7 months ago
Selected Answer: C
C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel