topic Re: How to standardized date in my database and apps in App Development

How to standardized date in my database and apps

Anonymous — Wed, 20 Jan 2016 20:07:34 GMT

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.

Re: How to standardized date in my database and apps

swuehl — Wed, 20 Jan 2016 22:15:50 GMT

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

Re: How to standardized date in my database and apps

reddy-s — Thu, 21 Jan 2016 00:13:37 GMT

Hi Bill,

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

Understanding the Master Calendar (video)

Canonical Date