topic How to calculate the quantity of fixed date range？ in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-quantity-of-fixed-date-range/m-p/1067172#M356741 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>now I want to calculate the quantity of fixed date range in Column F,see below<IMG alt="RTX截图未命名1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116555_RTX截图未命名1.png" style="height: 171px; width: 620px;" /></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">How</SPAN> <SPAN class="hps">to write</SPAN> <SPAN class="hps">an expression in Qlikview?</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">This is my expression:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P>=sum({1&lt;T@Date_num={'&gt;$(=max(T@Date_num)-4)&lt;=$(=max(T@Date_num))'}&gt;}T@Csum*T@Price)</P><P></P><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps">The problem is that</SPAN> <SPAN class="hps">all values</SPAN> <SPAN class="hps">are the same,</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps"><IMG alt="RTX截图未命名.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/116556_RTX截图未命名.png" style="height: auto;" /></SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></DIV><DIV dir="ltr"><P>Please suggest.</P><P></P><P>Thanks</P></DIV><DIV dir="ltr"><P></P></DIV></BODY></HTML> Wed, 02 Mar 2016 07:35:52 GMT limingthefirst 2016-03-02T07:35:52Z How to calculate the quantity of fixed date range？ https://community.qlik.com/t5/QlikView/How-to-calculate-the-quantity-of-fixed-date-range/m-p/1067172#M356741 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>now I want to calculate the quantity of fixed date range in Column F,see below<IMG alt="RTX截图未命名1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116555_RTX截图未命名1.png" style="height: 171px; width: 620px;" /></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">How</SPAN> <SPAN class="hps">to write</SPAN> <SPAN class="hps">an expression in Qlikview?</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">This is my expression:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P>=sum({1&lt;T@Date_num={'&gt;$(=max(T@Date_num)-4)&lt;=$(=max(T@Date_num))'}&gt;}T@Csum*T@Price)</P><P></P><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps">The problem is that</SPAN> <SPAN class="hps">all values</SPAN> <SPAN class="hps">are the same,</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps"><IMG alt="RTX截图未命名.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/116556_RTX截图未命名.png" style="height: auto;" /></SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></DIV><DIV dir="ltr"><P>Please suggest.</P><P></P><P>Thanks</P></DIV><DIV dir="ltr"><P></P></DIV></BODY></HTML> Wed, 02 Mar 2016 07:35:52 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-quantity-of-fixed-date-range/m-p/1067172#M356741 limingthefirst 2016-03-02T07:35:52Z