topic Re: Days Sales in QlikView https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697289#M1060650 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like,</P><P></P><P>sum({&lt;yourDate={"$(=Date(max(dateField),'DD/MM/YYYY')"}&gt;}sales).</P><P></P><P>Regards</P></BODY></HTML> Fri, 10 Oct 2014 06:01:02 GMT PrashantSangle 2014-10-10T06:01:02Z Days Sales https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697287#M1060648 <HTML><HEAD></HEAD><BODY><P>i want to calculate for the DAY sales.</P><P></P><P>let suppose today is 10/10/2014</P><P>I want to today sales only</P><P></P><P>what would be expression please help. I don't want to do it thru selection parameter.</P><P></P><P>my sales expression&nbsp;&nbsp; <STRONG>=sum(sales).</STRONG></P></BODY></HTML> Fri, 10 Oct 2014 05:56:52 GMT https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697287#M1060648 abhaysingh 2014-10-10T05:56:52Z Re: Days Sales https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697288#M1060649 <HTML><HEAD></HEAD><BODY><P>=Sum({&lt;Date_field={'$(=Today())<SPAN style="font-size: 10pt; line-height: 1.5em;">'}&gt;}Sales)</SPAN></P></BODY></HTML> Fri, 10 Oct 2014 05:59:04 GMT https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697288#M1060649 anbu1984 2014-10-10T05:59:04Z Re: Days Sales https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697289#M1060650 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like,</P><P></P><P>sum({&lt;yourDate={"$(=Date(max(dateField),'DD/MM/YYYY')"}&gt;}sales).</P><P></P><P>Regards</P></BODY></HTML> Fri, 10 Oct 2014 06:01:02 GMT https://community.qlik.com/t5/QlikView/Days-Sales/m-p/697289#M1060650 PrashantSangle 2014-10-10T06:01:02Z