topic Select the nearest value in QlikView https://community.qlik.com/t5/QlikView/Select-the-nearest-value/m-p/1117252#M368655 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using a Item rate cost table:</P><TABLE><TBODY><TR><TD>ItemId</TD><TD>Proveedor_Tarifa</TD><TD>Tarifa</TD><TD>Tarifa_Id</TD><TD>From</TD><TD>To</TD></TR><TR><TD>10357267</TD><TD>PROV00039</TD><TD>1,26</TD><TD>10357267-42370</TD><TD>01/01/2016</TD><TD></TD></TR><TR><TD>10357267</TD><TD>PROV00041</TD><TD>1,34</TD><TD>10357267-42401</TD><TD>01/02/2016</TD><TD></TD></TR></TBODY></TABLE><P></P><P>In the Item sales analysis table apart from sales, units etc, I would like to know the "nearest" rate from the selected date on top</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="2016-07-08_11h01_38.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130631_2016-07-08_11h01_38.png" style="height: 35px; width: 620px;" /></P><P></P><P>For example for July 2016 The selection should be rate 1/2/2016= 1,34&nbsp;&nbsp; and for 15/1/2016= 1,26</P><P></P><P>Many thank's guys</P></BODY></HTML> Fri, 08 Jul 2016 09:03:59 GMT ecabanas 2016-07-08T09:03:59Z Select the nearest value https://community.qlik.com/t5/QlikView/Select-the-nearest-value/m-p/1117252#M368655 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using a Item rate cost table:</P><TABLE><TBODY><TR><TD>ItemId</TD><TD>Proveedor_Tarifa</TD><TD>Tarifa</TD><TD>Tarifa_Id</TD><TD>From</TD><TD>To</TD></TR><TR><TD>10357267</TD><TD>PROV00039</TD><TD>1,26</TD><TD>10357267-42370</TD><TD>01/01/2016</TD><TD></TD></TR><TR><TD>10357267</TD><TD>PROV00041</TD><TD>1,34</TD><TD>10357267-42401</TD><TD>01/02/2016</TD><TD></TD></TR></TBODY></TABLE><P></P><P>In the Item sales analysis table apart from sales, units etc, I would like to know the "nearest" rate from the selected date on top</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="2016-07-08_11h01_38.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130631_2016-07-08_11h01_38.png" style="height: 35px; width: 620px;" /></P><P></P><P>For example for July 2016 The selection should be rate 1/2/2016= 1,34&nbsp;&nbsp; and for 15/1/2016= 1,26</P><P></P><P>Many thank's guys</P></BODY></HTML> Fri, 08 Jul 2016 09:03:59 GMT https://community.qlik.com/t5/QlikView/Select-the-nearest-value/m-p/1117252#M368655 ecabanas 2016-07-08T09:03:59Z Re: Select the nearest value https://community.qlik.com/t5/QlikView/Select-the-nearest-value/m-p/1117253#M368656 <HTML><HEAD></HEAD><BODY><P>Have a look at this post&nbsp; <A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>and the item on Creating an Interval from a Single Date</P><P><A href="https://community.qlik.com/qlik-blogpost/2960">Creating a Date Interval from a Single Date</A></P></BODY></HTML> Fri, 08 Jul 2016 09:06:14 GMT https://community.qlik.com/t5/QlikView/Select-the-nearest-value/m-p/1117253#M368656 Colin-Albert 2016-07-08T09:06:14Z