There is nothing impossible under the Sun if you are a Qlik developer.
Okay, that’s a bit of an exaggeration, but a skilled Qlik developer can indeed do magic!
You may scramble to deal with multiple date fields in other tools, but not with Qlik if you know how to.
In our upcoming webinar, we will show you a practical approach to get certified, so join now as it is FREE, and we have only 12 spots left out of 150.
Just as a brain teaser, here is the question that will test your skill if you want to pursue Qlik Sense or QlikView data architect certification.
Question: Use an order table to create a line chart to show # of orders placed and # of orders Shipped by Order MonthYear and ShipDate MonthYear, respectively (See the image below).
Which approach will you take to create a master calendar to fulfill the above requirement?
- Create 2 Master Calendars, one for ShipDate and one for OrderDate
- Create a Link table and 2 Master Calendars, one for ShipDate and one for OrderDate.
- Create a Link table and a Master Calendar
- Create a Master Calendar and associate it with ShipDate and OrderDate
Can you answer this question? Here is the sample data set in case if you want to work on the solution yourself.
Don’t forget to join us on the FREE webinar since we will reveal the answer and even the step-by-step solution along with useful tips to help you get certified!
It shoud be D
Option 3 or Another is canonical date approach
3 Create a Link table and a Master Calendar
It will be 3, 3 rd will also do the same what 4 is doing. With link table we connect master calendar and a flag in link table will specify which date it is – order or shipping