O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Master calendar

As a best practice, it is always better to keep time-related fields in a separate table outside of the fact table. This is particularly helpful when you want to see all the dates, and not just the dates when specific events occurred. In our case, we should be able to see all the dates, and not just the dates when an order was made, because in real-life scenarios there may be days or months in which no order was made. It is also important to remember that QlikView stores dates as numbers:

  1. Use the same QVW file QlikViewEssentials_Chap4_LinkTable.qvw.
  2. Invoke the script editor. Navigate to the Orders Tab. Go to the load script of Orders and comment the Month field by using //. We will be creating this field in the master calendar.
  3. Create ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required