topic Re: Set Analysis for two dates selected in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550397#M205561 <HTML><HEAD></HEAD><BODY><P>If I understand your requirements correctly, and assuming that both dates are from the same field [Order Date], this will help (maybe you need some variations of this):</P><P>sum({&lt;[Order Date]={"$(=date(max([Order Date])))"}&gt;} [Order Value]) - sum({&lt;[Order Date]={"$(=date(min([Order Date])))"}&gt;} [Order Value])</P><P></P><P>Regards,</P><P>Michael</P><P><BR /> </P></BODY></HTML> Wed, 30 Oct 2013 17:52:15 GMT Anonymous 2013-10-30T17:52:15Z Set Analysis for two dates selected https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550395#M205559 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am trying to calculate the difference between order counts and order values for two dates selected.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please find attached the data and output files.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks in advance</P></BODY></HTML> Wed, 30 Oct 2013 16:52:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550395#M205559 2013-10-30T16:52:18Z Re: Set Analysis for two dates selected https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550396#M205560 <HTML><HEAD></HEAD><BODY><P>Please help I have been struck for a while</P></BODY></HTML> Wed, 30 Oct 2013 17:12:09 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550396#M205560 2013-10-30T17:12:09Z Re: Set Analysis for two dates selected https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550397#M205561 <HTML><HEAD></HEAD><BODY><P>If I understand your requirements correctly, and assuming that both dates are from the same field [Order Date], this will help (maybe you need some variations of this):</P><P>sum({&lt;[Order Date]={"$(=date(max([Order Date])))"}&gt;} [Order Value]) - sum({&lt;[Order Date]={"$(=date(min([Order Date])))"}&gt;} [Order Value])</P><P></P><P>Regards,</P><P>Michael</P><P><BR /> </P></BODY></HTML> Wed, 30 Oct 2013 17:52:15 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-two-dates-selected/m-p/550397#M205561 Anonymous 2013-10-30T17:52:15Z