topic Calculate condition in a chart in QlikView https://community.qlik.com/t5/QlikView/Calculate-condition-in-a-chart/m-p/317198#M1186077 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new to Qlikview and i'm trying to calculate a condition in a chart, as follows:</P><P></P><P>Sum((Amount) if(OrderDate = CurrentDate))</P><P></P><P>Basically I want to Sum the Sales Amount only if the 2 dates match.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 06 Oct 2011 09:58:17 GMT 2011-10-06T09:58:17Z Calculate condition in a chart https://community.qlik.com/t5/QlikView/Calculate-condition-in-a-chart/m-p/317198#M1186077 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new to Qlikview and i'm trying to calculate a condition in a chart, as follows:</P><P></P><P>Sum((Amount) if(OrderDate = CurrentDate))</P><P></P><P>Basically I want to Sum the Sales Amount only if the 2 dates match.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 06 Oct 2011 09:58:17 GMT https://community.qlik.com/t5/QlikView/Calculate-condition-in-a-chart/m-p/317198#M1186077 2011-10-06T09:58:17Z Re: Calculate condition in a chart https://community.qlik.com/t5/QlikView/Calculate-condition-in-a-chart/m-p/317199#M1186078 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this SUM(IF(OrderDate = CurrentDate,Amount,0)) </P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 06 Oct 2011 10:12:09 GMT https://community.qlik.com/t5/QlikView/Calculate-condition-in-a-chart/m-p/317199#M1186078 Sokkorn 2011-10-06T10:12:09Z