Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cm
Contributor II
Contributor II

Date Picker Extension with Multiple Date Fields

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?

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor II
Contributor II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist III
Specialist III

use master calendar and join date with all other tables

Channa