Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

storagepro
New Contributor

How to standardized date in my database and apps

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.  

Capture.GIF

2 Replies
MVP
MVP

Re: How to standardized date in my database and apps

reddys310
Honored Contributor II

Re: How to standardized date in my database and apps

Hi Bill,

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

Understanding the Master Calendar (video)

Canonical Date

Community Browser