topic Set Analysis using a date field in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-using-a-date-field/m-p/329172#M121151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>am trying to get a total sales value of all invoices for a particular promotional date. The set analysis I have written is as follows but does not seem to be working. Can anyone let me know what I am doing that is incorrect</P><P></P><P></P><P>many thanks</P><P></P><P></P><P></P><P><SPAN style="color: #008000; font-size: 8pt;"></SPAN></P><P>=sum({$&lt;Invoice_Date = {$(=Promo_Start_Date)}&gt;}[Sales_Value])</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 18 Nov 2011 15:52:06 GMT 2011-11-18T15:52:06Z Set Analysis using a date field https://community.qlik.com/t5/QlikView/Set-Analysis-using-a-date-field/m-p/329172#M121151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>am trying to get a total sales value of all invoices for a particular promotional date. The set analysis I have written is as follows but does not seem to be working. Can anyone let me know what I am doing that is incorrect</P><P></P><P></P><P>many thanks</P><P></P><P></P><P></P><P><SPAN style="color: #008000; font-size: 8pt;"></SPAN></P><P>=sum({$&lt;Invoice_Date = {$(=Promo_Start_Date)}&gt;}[Sales_Value])</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 18 Nov 2011 15:52:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-using-a-date-field/m-p/329172#M121151 2011-11-18T15:52:06Z Set Analysis using a date field https://community.qlik.com/t5/QlikView/Set-Analysis-using-a-date-field/m-p/329173#M121152 <HTML><HEAD></HEAD><BODY><P>try with date(Promo_Start_Date)</P></BODY></HTML> Fri, 18 Nov 2011 18:00:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-using-a-date-field/m-p/329173#M121152 2011-11-18T18:00:18Z