topic Sum Week in App Development https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136851#M9601 <HTML><HEAD></HEAD><BODY><P>Working on a measure that would show me total sales from last full&nbsp; week based on todays date.&nbsp; So far I have this expression but it is not functioning:&nbsp; </P><P></P><P>sum(aggr(sum(distinct{$&lt;[completed_date.autoCalendar.Week]={"$(=Week(Today(1) )"}&gt;}(order_total)), order_id))</P><P></P><P>Any help on with this expression is appreciated.&nbsp; Thanks in advance</P></BODY></HTML> Thu, 30 Aug 2018 17:17:06 GMT Anonymous 2018-08-30T17:17:06Z Sum Week https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136851#M9601 <HTML><HEAD></HEAD><BODY><P>Working on a measure that would show me total sales from last full&nbsp; week based on todays date.&nbsp; So far I have this expression but it is not functioning:&nbsp; </P><P></P><P>sum(aggr(sum(distinct{$&lt;[completed_date.autoCalendar.Week]={"$(=Week(Today(1) )"}&gt;}(order_total)), order_id))</P><P></P><P>Any help on with this expression is appreciated.&nbsp; Thanks in advance</P></BODY></HTML> Thu, 30 Aug 2018 17:17:06 GMT https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136851#M9601 Anonymous 2018-08-30T17:17:06Z Re: Sum Week https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136852#M9602 <HTML><HEAD></HEAD><BODY><P>May be because you are missing a parenthesis</P><P></P><P><STRONG>Sum(Aggr(Sum(DISTINCT {$&lt;[completed_date.autoCalendar.Week] = {"$(=Week(Today(1))<SPAN style="color: #ff0000; font-size: 14pt;">)</SPAN>"}&gt;} order_total), order_id))</STRONG></P></BODY></HTML> Thu, 30 Aug 2018 17:19:35 GMT https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136852#M9602 sunny_talwar 2018-08-30T17:19:35Z Re: Sum Week https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136853#M9603 <HTML><HEAD></HEAD><BODY><P>Made that change, but still not functioning.&nbsp; Thanks though, probably not going to hurt to have the correct amount of parenthesis in espression.</P></BODY></HTML> Thu, 30 Aug 2018 17:22:17 GMT https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136853#M9603 Anonymous 2018-08-30T17:22:17Z Re: Sum Week https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136854#M9604 <HTML><HEAD></HEAD><BODY><P>Can you show the script for the derived calendar?</P></BODY></HTML> Thu, 30 Aug 2018 17:24:12 GMT https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136854#M9604 sunny_talwar 2018-08-30T17:24:12Z Re: Sum Week https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136855#M9605 <HTML><HEAD></HEAD><BODY><P>Not sure how to do that, maybe I don't have access to it?</P></BODY></HTML> Thu, 30 Aug 2018 18:39:26 GMT https://community.qlik.com/t5/App-Development/Sum-Week/m-p/136855#M9605 Anonymous 2018-08-30T18:39:26Z