topic Re: Filter on multiple fields in QlikView https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830648#M533045 <HTML><HEAD></HEAD><BODY><P>You may find it useful to create a master of master calendar (<A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>) which would help you in making a selection in more than one calendar as a time.</P><P></P><P>Hope you will find this to be useful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Apr 2015 14:14:47 GMT sunny_talwar 2015-04-14T14:14:47Z Filter on multiple fields https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830647#M533044 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello everyone,</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">a number of</SPAN> <SPAN class="hps">date fields</SPAN> <SPAN class="hps">called</SPAN> <SPAN class="hps">differently</SPAN> <SPAN class="hps atn">(</SPAN>eg <SPAN class="hps">data1</SPAN>, <SPAN class="hps">data2</SPAN>, <SPAN class="hps">data3</SPAN>) <SPAN class="hps">I would like to</SPAN> <SPAN class="hps">enter a</SPAN> <SPAN class="hps">date filter</SPAN> <SPAN class="hps">that works</SPAN> <SPAN class="hps">on all three</SPAN> <SPAN class="hps">date fields</SPAN>, <SPAN class="hps">the filter</SPAN> <SPAN class="hps">must</SPAN> <SPAN class="hps">also</SPAN> <SPAN class="hps">select records</SPAN> <SPAN class="hps">with date</SPAN> <SPAN class="hps">equal to the</SPAN> <SPAN class="hps">selected date</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">all records with</SPAN> <SPAN class="hps">date</SPAN> <SPAN class="hps">less</SPAN> <SPAN class="hps">the selected date</SPAN> <SPAN class="hps">in the filter</SPAN>.<BR /><BR /> <SPAN class="hps">someone</SPAN> <SPAN class="hps">tell me</SPAN> <SPAN class="hps">would know</SPAN> <SPAN class="hps">how to do</SPAN>?<BR /><BR /> <SPAN class="hps">Thanks for collaboration</SPAN><BR /><BR /> <SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Tue, 14 Apr 2015 14:02:45 GMT https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830647#M533044 warrentk80 2015-04-14T14:02:45Z Re: Filter on multiple fields https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830648#M533045 <HTML><HEAD></HEAD><BODY><P>You may find it useful to create a master of master calendar (<A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>) which would help you in making a selection in more than one calendar as a time.</P><P></P><P>Hope you will find this to be useful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Apr 2015 14:14:47 GMT https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830648#M533045 sunny_talwar 2015-04-14T14:14:47Z Re: Filter on multiple fields https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830649#M533046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I agree with Sunindia the master calendar is the best option.</P><P></P><P><A href="http://www.qlik4life.com/master-calendar-creation-in-qlikview/" title="http://www.qlik4life.com/master-calendar-creation-in-qlikview/">Master Calendar Creation in QlikviewQlikview for life(Qlik4Life) The site is based on Qlikview Stuffs for Developers and…</A></P><P></P><P>Regards.</P></BODY></HTML> Tue, 14 Apr 2015 14:39:19 GMT https://community.qlik.com/t5/QlikView/Filter-on-multiple-fields/m-p/830649#M533046 Anonymous 2015-04-14T14:39:19Z