topic Sum expression based on &gt;date in QlikView https://community.qlik.com/t5/QlikView/Sum-expression-based-on-gt-date/m-p/150793#M28754 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I dont think you need the all in the statement</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Sum(if (DateMonth &gt;= Date('10/11/08'),sales)/Sum( if(datemonth &gt;= date('10/11/08'),Purchases)</PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Fri, 31 Jul 2009 17:28:42 GMT 2009-07-31T17:28:42Z Sum expression based on >date https://community.qlik.com/t5/QlikView/Sum-expression-based-on-gt-date/m-p/150792#M28753 <HTML><HEAD></HEAD><BODY><P>Hi I have the following expression</P><P>=Sum(all if (DateMonth &gt;= Date('10/11/08'),sales)/Sum(all if(datemonth &gt;= date('10/11/08'),Purchases)</P><P>however it isn't returning anything, anyone got any ideas what is wrong with the expression.</P><P>Thanks in advance</P></BODY></HTML> Fri, 31 Jul 2009 17:20:09 GMT https://community.qlik.com/t5/QlikView/Sum-expression-based-on-gt-date/m-p/150792#M28753 2009-07-31T17:20:09Z Sum expression based on >date https://community.qlik.com/t5/QlikView/Sum-expression-based-on-gt-date/m-p/150793#M28754 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I dont think you need the all in the statement</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Sum(if (DateMonth &gt;= Date('10/11/08'),sales)/Sum( if(datemonth &gt;= date('10/11/08'),Purchases)</PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Fri, 31 Jul 2009 17:28:42 GMT https://community.qlik.com/t5/QlikView/Sum-expression-based-on-gt-date/m-p/150793#M28754 2009-07-31T17:28:42Z