How to standardized date in my database and apps

[Anonymous]

Hi, I am new to Qlik and having some questions on standardizing date in my apps. For example, I have two apps: cash receipt and rental record. However, I need to create two filters (also rename date as cash date and rental date) in order to get the result that I want in one reporting table. The data model is link by store number instead of date. I have tried to use "join" syntax, but not successfully. How could I just use one date to manipulate my apps instead of many? Please help. Much appreciate.  

[swuehl]

Not sure if I understood your request, but I think these blog posts may be helpful:

Why You sometimes should Load a Master Table several times

Canonical Date

Re: Tutorial - Using Common Date Dimensions and Shared Calendars

[reddy-s]

Hi Bill,

Make use of a Master Calendar and Canonical Date to achieve this.

Understanding the Master Calendar (video)

Canonical Date