topic Re: Can I use the same data search for several date fields? in QlikView https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937267#M649177 <HTML><HEAD></HEAD><BODY><P>You need to look at Canonical Calendar for your requirement. Have a look here: <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Mon, 17 Aug 2015 11:15:10 GMT sunny_talwar 2015-08-17T11:15:10Z Can I use the same data search for several date fields? https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937266#M649176 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a xls sheet when 4 weeks e.g</P><P>Week for drafting</P><P>Week for review</P><P>Week for correction</P><P>Week for approval</P><P>Can I create a week field and use the same week field to search in all of the 4 weeks in the xls?</P><P></P><P>Example if I enter week 33 then my table list would list all entries that matches week 33 for either drafting, reviewing, correction or approval?</P><P></P><P>I tried to associate all the weeks with e.g. WeekNumber but gets an error</P><P>Any good ideas?</P><P></P><P>Thanks</P><P>Peter</P></BODY></HTML> Mon, 17 Aug 2015 11:11:02 GMT https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937266#M649176 Anonymous 2015-08-17T11:11:02Z Re: Can I use the same data search for several date fields? https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937267#M649177 <HTML><HEAD></HEAD><BODY><P>You need to look at Canonical Calendar for your requirement. Have a look here: <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Mon, 17 Aug 2015 11:15:10 GMT https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937267#M649177 sunny_talwar 2015-08-17T11:15:10Z Re: Can I use the same data search for several date fields? https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937268#M649178 <HTML><HEAD></HEAD><BODY><P>Beautiful thanks, I'll have a look.</P></BODY></HTML> Mon, 17 Aug 2015 11:17:11 GMT https://community.qlik.com/t5/QlikView/Can-I-use-the-same-data-search-for-several-date-fields/m-p/937268#M649178 Anonymous 2015-08-17T11:17:11Z