Date Picker Extension with Multiple Date Fields

[cm]

Anybody know how to set up the Date Picker to pull from all date fields from all data sources?

I have 10 sources on the back end, all associated through a 4-digit number (not the date), but each source has a date column as well. When I set up the Date Picker now, I must choose only one field recognized by the AutoCalendar (and hence, only one of the 10 data sources). Filtering on a date, in that scenario, the KPIs only localize for that one data set.

If I try to create a master calendar on the back end and associate the 10 sources with it, I get the circular reference error.

Anyone had this problem?

[rwunderlich]

You will want to set up a canonical date. Download a Qlik Sense example here. 

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[cm]

Thanks Rob. I’ve read it may be better to go into the script and change all dates to a single common term. What is your thought on that?

[rwunderlich]

Yes, if I understand your question correctly you will need to create the common date in the script, and associate with your other dates. 

-Rob

[Channa]

use master calendar and join date with all other tables