topic Date &lt;= Chart Date Dimension in QlikView https://community.qlik.com/t5/QlikView/Date-lt-Chart-Date-Dimension/m-p/735470#M1054448 <HTML><HEAD></HEAD><BODY><P>I have a dimension in script </P><P></P><P>Table1: </P><P>SYMBOL</P><P>ASOFDATE </P><P>Value</P><P></P><P></P><P>table2:</P><P>SYMBOL</P><P>UPdateDate</P><P>Value</P><P></P><P>I create a chart with a dimension symbol, AsOfDate. </P><P></P><P>I need a calculated expression that get the max UpdateDate where UpdateDate &lt;= asOfdate. </P><P></P><P></P><P>I tried the following except </P><P>=DATE(Max({&lt;UPdateDate= {"&lt;=$(=Max(AsOfDate))"}&gt;} UPdateDate)) </P><P></P><P>Unfortunate;ly if i have 7 asOfDatesit compares it to the Largest date&nbsp; and I want it to be compared to the Date in the Chart dimension.</P><P></P><P>How do i accomplish this?</P></BODY></HTML> Wed, 15 Oct 2014 19:42:44 GMT 2014-10-15T19:42:44Z Date <= Chart Date Dimension https://community.qlik.com/t5/QlikView/Date-lt-Chart-Date-Dimension/m-p/735470#M1054448 <HTML><HEAD></HEAD><BODY><P>I have a dimension in script </P><P></P><P>Table1: </P><P>SYMBOL</P><P>ASOFDATE </P><P>Value</P><P></P><P></P><P>table2:</P><P>SYMBOL</P><P>UPdateDate</P><P>Value</P><P></P><P>I create a chart with a dimension symbol, AsOfDate. </P><P></P><P>I need a calculated expression that get the max UpdateDate where UpdateDate &lt;= asOfdate. </P><P></P><P></P><P>I tried the following except </P><P>=DATE(Max({&lt;UPdateDate= {"&lt;=$(=Max(AsOfDate))"}&gt;} UPdateDate)) </P><P></P><P>Unfortunate;ly if i have 7 asOfDatesit compares it to the Largest date&nbsp; and I want it to be compared to the Date in the Chart dimension.</P><P></P><P>How do i accomplish this?</P></BODY></HTML> Wed, 15 Oct 2014 19:42:44 GMT https://community.qlik.com/t5/QlikView/Date-lt-Chart-Date-Dimension/m-p/735470#M1054448 2014-10-15T19:42:44Z