Refer to the exhibitA data architect is working on an app that contains orders, invoices,...

Qlik QSDA2022 Question Answer

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

Create a Month field for each of the three dates in the fact table and use that in the chart

Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

QSDA2022 PDF/Engine

Get 75% Discount on All Products, Use Coupon: "ac75sure"