topic Re: How do I write an expression utilizing the current week number? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494182#M1147892 <HTML><HEAD></HEAD><BODY><P>If you want to just calculate the weekly average of sales(not the evolution), you can do:</P><P></P><P>sum(Sales)/Week(Date(Today))</P><P></P><P>Is that what you are looking for?</P></BODY></HTML> Wed, 14 Aug 2013 13:39:46 GMT 2013-08-14T13:39:46Z How do I write an expression utilizing the current week number? https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494181#M1147891 <HTML><HEAD></HEAD><BODY><P>I want to create an expression that calculates the average weekly sales of a product.&nbsp; I have the total of sales, but can't see how automatically include the current week number as a differential.</P><P></P><P>I have tried using the 'average' function, but this just averages the total number of entries - there will be more than one entry per week.</P><P></P><P>Can I use the current day to identify the current week, and then use that in the expression?</P><P></P><P>Thanks in advance for any help.</P></BODY></HTML> Wed, 14 Aug 2013 13:35:06 GMT https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494181#M1147891 ljackson 2013-08-14T13:35:06Z Re: How do I write an expression utilizing the current week number? https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494182#M1147892 <HTML><HEAD></HEAD><BODY><P>If you want to just calculate the weekly average of sales(not the evolution), you can do:</P><P></P><P>sum(Sales)/Week(Date(Today))</P><P></P><P>Is that what you are looking for?</P></BODY></HTML> Wed, 14 Aug 2013 13:39:46 GMT https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494182#M1147892 2013-08-14T13:39:46Z Re: How do I write an expression utilizing the current week number? https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494183#M1147893 <HTML><HEAD></HEAD><BODY><P>week(today()) will return the week number of today. So perhaps sum(Sales)/week(today()) is what you're looking for.</P></BODY></HTML> Wed, 14 Aug 2013 14:18:59 GMT https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494183#M1147893 Gysbert_Wassenaar 2013-08-14T14:18:59Z Re: How do I write an expression utilizing the current week number? https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494184#M1147894 <HTML><HEAD></HEAD><BODY><P>Thank you, that worked a treat!&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 14 Aug 2013 14:47:19 GMT https://community.qlik.com/t5/QlikView/How-do-I-write-an-expression-utilizing-the-current-week-number/m-p/494184#M1147894 ljackson 2013-08-14T14:47:19Z