topic Re: Date intervals in QlikView https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426295#M561471 <HTML><HEAD></HEAD><BODY><P>Try <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">this</A> first instead of using intervalmatch</P></BODY></HTML> Fri, 05 Apr 2013 13:29:56 GMT Gysbert_Wassenaar 2013-04-05T13:29:56Z Date intervals https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426293#M561469 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Friends! On the agenda I was overtaken by the following task:</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">I has a table with the SALE DATE field which contains sale date. also there is a table with PRICING DATE field which contains from 2 to 10 dates and each date <SPAN style="color: #525252; background-color: #ffffff;">corresponds</SPAN> му the price. Okay. And the task washing consists what to select actual date of pricing, i.e. to understand how my date of sale gets to what interval of dates (from 10 dates of pricing for example).</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">SALE DATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRICING DATE</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">01.01.2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30.09.2011</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">02.02.2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31.12.2011</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.02.2012</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02.04.2012</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Help me to apply the intervalmatch() function or perhaps there is an alternative solution of this task...</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Thnx...<BR /></SPAN></P></BODY></HTML> Fri, 05 Apr 2013 13:07:26 GMT https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426293#M561469 2013-04-05T13:07:26Z Re: Date intervals https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426294#M561470 <HTML><HEAD></HEAD><BODY><P>I.e. from a set of all dates to select the upper and lower dates which most lie to sale date closer.</P></BODY></HTML> Fri, 05 Apr 2013 13:11:31 GMT https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426294#M561470 2013-04-05T13:11:31Z Re: Date intervals https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426295#M561471 <HTML><HEAD></HEAD><BODY><P>Try <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">this</A> first instead of using intervalmatch</P></BODY></HTML> Fri, 05 Apr 2013 13:29:56 GMT https://community.qlik.com/t5/QlikView/Date-intervals/m-p/426295#M561471 Gysbert_Wassenaar 2013-04-05T13:29:56Z