https://community.qlik.com/t5/QlikView/Calculated-dimension-with-min-and-max-dates/m-p/353219#M131050 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have a date field as DateReceived, My user will select one date, so from that selected date to 30 days back, i need to show a bar chart showing emailcount on it, something like below.</P><P></P><P>I am struggling to write a calculated dimension for this. i want to display all the possible dates in dimension which has email counts. </P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P>I have the below code to calculate 30 days.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13396771409194399" jivemacro_uid="_13396771409194399"><P>=Count( {&lt;DateReceived={"&gt;=$(=Date(Max(Floor(Num(DateReceived)))-30))&lt;=$(=Date(Max(DateReceived)))"}&gt;} distinct [Email ID of Notice Recipient])</P></PRE><P></P><P></P><P>THanks</P><P>Ranjith</P></BODY></HTML> Thu, 14 Jun 2012 12:35:58 GMT renjithpl 2012-06-14T12:35:58Z https://community.qlik.com/t5/QlikView/Calculated-dimension-with-min-and-max-dates/m-p/353219#M131050 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have a date field as DateReceived, My user will select one date, so from that selected date to 30 days back, i need to show a bar chart showing emailcount on it, something like below.</P><P></P><P>I am struggling to write a calculated dimension for this. i want to display all the possible dates in dimension which has email counts. </P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P>I have the below code to calculate 30 days.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13396771409194399" jivemacro_uid="_13396771409194399"><P>=Count( {&lt;DateReceived={"&gt;=$(=Date(Max(Floor(Num(DateReceived)))-30))&lt;=$(=Date(Max(DateReceived)))"}&gt;} distinct [Email ID of Notice Recipient])</P></PRE><P></P><P></P><P>THanks</P><P>Ranjith</P></BODY></HTML> Thu, 14 Jun 2012 12:35:58 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-min-and-max-dates/m-p/353219#M131050 renjithpl 2012-06-14T12:35:58Z https://community.qlik.com/t5/QlikView/Calculated-dimension-with-min-and-max-dates/m-p/353220#M131051 <HTML><HEAD></HEAD><BODY><P>HI ranjiby </P><P>may i kn what your expression gives result.</P><P>is it showing only selected date and last month date data.??</P><P>thanx</P><P>rohit</P></BODY></HTML> Thu, 14 Jun 2012 12:57:17 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-min-and-max-dates/m-p/353220#M131051 rohit214 2012-06-14T12:57:17Z