topic Re: Date Range syntax in QlikView https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853922#M299341 <HTML><HEAD></HEAD><BODY><P>HI Arjun</P><P></P><P>Use Master Calendar </P><P>and Use Debit &amp; Credit in Expressions</P><P>you Can Choose form Date Range</P></BODY></HTML> Fri, 17 Apr 2015 09:40:09 GMT rajkumarb 2015-04-17T09:40:09Z Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853917#M299336 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">From Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">To Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Marks</TH></TR><TR><TD style="padding: 2px;">01012014</TD><TD style="padding: 2px;">17042014</TD><TD style="padding: 2px;">20</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">18042014</SPAN></TD><TD><SPAN style="font-size: 13.3333330154419px;">17042015</SPAN></TD><TD>15</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">16052014</SPAN></TD><TD><SPAN style="font-size: 13.3333330154419px;">17062014</SPAN></TD><TD>23</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">17062014</SPAN></TD><TD><SPAN style="font-size: 13.3333330154419px;">17082014</SPAN></TD><TD>21</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">17072014</SPAN></TD><TD><SPAN style="font-size: 13.3333330154419px;">17092014</SPAN></TD><TD>22</TD></TR></TBODY></TABLE><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I want to take sum of Marks. For a range of dates.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">can someone please help me the <STRONG>syntax of date range</STRONG>?</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">TIA</P></BODY></HTML> Fri, 17 Apr 2015 07:55:42 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853917#M299336 2015-04-17T07:55:42Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853918#M299337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like</P><P></P><P>sum(if(FromDate&gt;=$(min(FromDate) and ToDate&lt;=$(max(FromDate)))Marks))</P><P></P><P>regards</P></BODY></HTML> Fri, 17 Apr 2015 07:59:49 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853918#M299337 PrashantSangle 2015-04-17T07:59:49Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853919#M299338 <HTML><HEAD></HEAD><BODY><P>Cuold ypou explain better?</P></BODY></HTML> Fri, 17 Apr 2015 08:02:01 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853919#M299338 alexandros17 2015-04-17T08:02:01Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853920#M299339 <HTML><HEAD></HEAD><BODY><P>I have a table with three columns.</P><P></P><P>Date, Debit and Credit.</P><P></P><P>How do I see the debit for a particular period?</P></BODY></HTML> Fri, 17 Apr 2015 09:35:07 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853920#M299339 2015-04-17T09:35:07Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853921#M299340 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">That did not work in my case.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I have a table with three columns.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Date, Debit and Credit.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">How do I see the debit for a particular period?</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I hope this helps you to understand the case better</P></BODY></HTML> Fri, 17 Apr 2015 09:36:05 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853921#M299340 2015-04-17T09:36:05Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853922#M299341 <HTML><HEAD></HEAD><BODY><P>HI Arjun</P><P></P><P>Use Master Calendar </P><P>and Use Debit &amp; Credit in Expressions</P><P>you Can Choose form Date Range</P></BODY></HTML> Fri, 17 Apr 2015 09:40:09 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853922#M299341 rajkumarb 2015-04-17T09:40:09Z Re: Date Range syntax https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853923#M299342 <HTML><HEAD></HEAD><BODY><P>are u looking to see ur debit between two dates? if yes..u have to create &amp; use 2 calendar objects one for from date and seconde for todate.</P><P></P><P>from date &amp; todate objects u can create through ur date field.</P></BODY></HTML> Fri, 17 Apr 2015 09:40:26 GMT https://community.qlik.com/t5/QlikView/Date-Range-syntax/m-p/853923#M299342 buzzy996 2015-04-17T09:40:26Z