topic How to control multiple dates using common calendar (not linked to any dates) ? in QlikView

How to control multiple dates using common calendar (not linked to any dates) ?

sarangmmehta — Wed, 25 Nov 2015 13:06:04 GMT

Hi All,

I have 6-8 tables in my data model which consists of 8-10 dates spread across different tables.

I cannot link all the dates to the common calendar because it will create loops.

Also I cannot concatenate the data as there is a section of data which contains multiple dates.

For eg: Outstanding data has multiple 2-3 dates which needs to be considered.

i.e. a single row has 2-3 dates associated with it.

Even the link table will not work.

My query : can I control all the dates using common calendar (which will not be linked to any dates) and set analysis ?

I want to create a chart using common calendar dates(year, month) as a dimension and use two expression (sales amount using sell date) and (budget using budget date).

And the same numbers should be shown in text objects as YTD or MTD.

Can I do that ?

Thanks all in advance.

Regards,

Sarang M. Mehta

Re: How to control multiple dates using common calendar (not linked to any dates) ?

sunny_talwar — Wed, 25 Nov 2015 13:54:45 GMT

See if the idea on this blog help you out: Qlik Design Blog : Canonical Date | Qlik Community

Re: How to control multiple dates using common calendar (not linked to any dates) ?

sarangmmehta — Thu, 26 Nov 2015 03:43:26 GMT

Hi Sunny,

Thanks for the revert. I saw the blog that you suggested ( a bit tough to understand).

But if I understand it correctly, that canonical dates will work for one primary id (i.e. OrderID).

What if i have few other tables (for eg Customer table with CId with 1-2 dates, outstanding table with 2 dates and one more table with 2 more dates in it) ?

Thanks in advance.

Re: How to control multiple dates using common calendar (not linked to any dates) ?

Anonymous — Thu, 26 Nov 2015 05:14:00 GMT

Adding further to Sunny's suggestion, see these threads as well:

Using Multiple Dates With Master Calendar

Linking master calendar to multiple tables

Handling Multiple Calendars.qvw

Hope this will help!!