topic Dates and Calculated Dimensions in QlikView https://community.qlik.com/t5/QlikView/Dates-and-Calculated-Dimensions/m-p/190039#M52688 <HTML><HEAD></HEAD><BODY><P>Here was the answer <IMG alt="Geeked" src="http://community.qlik.com/emoticons/emotion-15.gif" /></P><P></P><P>=if(Date &gt;= '$(vStartDate)',Date)</P><BR /><BR /></BODY></HTML> Fri, 28 Jan 2011 00:54:07 GMT james 2011-01-28T00:54:07Z Dates and Calculated Dimensions https://community.qlik.com/t5/QlikView/Dates-and-Calculated-Dimensions/m-p/190038#M52687 <HTML><HEAD></HEAD><BODY><P>All, I currently have a line chart that uses Date as the Dimension, 01/02/2011, 01/03/2011 etc.</P><P></P><P>My expression is using set anlaysis =date(Max({$&lt;Date={'&gt;$(vStartDate) &lt;=$(vEndDate)'}&gt;}Date)) which is grabbing for this example 12/31/2010 through 01/26/2011</P><P></P><P>My issue is that the chart renders all dates at the bottom 01/01/2008 - 01/26/2011 yet the data is only for 12/31/2010 through 01/26/2011</P><P></P><P>How can i make the dimension know i only want to show those above dates?</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3401_sourceID:3401" /></P><P>So that the chart below is only those dates</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3402_sourceID:3402" /></P></BODY></HTML> Fri, 28 Jan 2011 00:23:57 GMT https://community.qlik.com/t5/QlikView/Dates-and-Calculated-Dimensions/m-p/190038#M52687 james 2011-01-28T00:23:57Z Dates and Calculated Dimensions https://community.qlik.com/t5/QlikView/Dates-and-Calculated-Dimensions/m-p/190039#M52688 <HTML><HEAD></HEAD><BODY><P>Here was the answer <IMG alt="Geeked" src="http://community.qlik.com/emoticons/emotion-15.gif" /></P><P></P><P>=if(Date &gt;= '$(vStartDate)',Date)</P><BR /><BR /></BODY></HTML> Fri, 28 Jan 2011 00:54:07 GMT https://community.qlik.com/t5/QlikView/Dates-and-Calculated-Dimensions/m-p/190039#M52688 james 2011-01-28T00:54:07Z