topic Re: Weekly Sales in QlikView https://community.qlik.com/t5/QlikView/Weekly-Sales/m-p/24541#M4043 <HTML><HEAD></HEAD><BODY><P>which week sales you want?</P><P>this takes you current week</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({$&lt;Year={"$(=max(Year))"},Week={"$(=max(Week(Date)))"}&gt;}[Sales])</SPAN></P></BODY></HTML> Wed, 28 Mar 2018 14:23:56 GMT Chanty4u 2018-03-28T14:23:56Z Weekly Sales https://community.qlik.com/t5/QlikView/Weekly-Sales/m-p/24540#M4042 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I'm new to qliksense and am battling abit with building expressions.</P><P>I have a date (day, week, month, year) field and a nett sales (total sales) field.</P><P>How do I build an expression to just return sales for the week?</P></BODY></HTML> Wed, 28 Mar 2018 13:45:20 GMT https://community.qlik.com/t5/QlikView/Weekly-Sales/m-p/24540#M4042 gisellevaleta 2018-03-28T13:45:20Z Re: Weekly Sales https://community.qlik.com/t5/QlikView/Weekly-Sales/m-p/24541#M4043 <HTML><HEAD></HEAD><BODY><P>which week sales you want?</P><P>this takes you current week</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({$&lt;Year={"$(=max(Year))"},Week={"$(=max(Week(Date)))"}&gt;}[Sales])</SPAN></P></BODY></HTML> Wed, 28 Mar 2018 14:23:56 GMT https://community.qlik.com/t5/QlikView/Weekly-Sales/m-p/24541#M4043 Chanty4u 2018-03-28T14:23:56Z