topic Re: Date Picker Extension with Multiple Date Fields in Visualization and Usability

Date Picker Extension with Multiple Date Fields

cm — Fri, 01 Mar 2019 18:52:50 GMT

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?

Re: Date Picker Extension with Multiple Date Fields

rwunderlich — Fri, 01 Mar 2019 21:54:27 GMT

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

Re: Date Picker Extension with Multiple Date Fields

cm — Sat, 02 Mar 2019 00:15:46 GMT

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?

Re: Date Picker Extension with Multiple Date Fields

rwunderlich — Sat, 02 Mar 2019 16:26:01 GMT

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

Re: Date Picker Extension with Multiple Date Fields

Channa — Sat, 02 Mar 2019 16:42:26 GMT

use master calendar and join date with all other tables