Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Re: Tutorial - Using Common Date Dimensions and Shared Calendars
Hi Bill,
Make use of a Master Calendar and Canonical Date to achieve this.