topic AW:Average Sales in QlikView https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306819#M1199992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can use Week(datefield) and with set analysis you get sales of the week before - pardon for entering it twice,</P></BODY></HTML> Fri, 18 Feb 2011 13:59:06 GMT brenner_martina 2011-02-18T13:59:06Z Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306817#M1199990 <HTML><HEAD></HEAD><BODY><P>Hi, can anyone help me on how to display the sales for the last FULL week (MONDAY to SUNDAY).</P><P>I have sales being loaded in daily, On my chart i have a dimension that displays the sales for the date selected, but i also want a column next to it that displays the sales for the last full week. this figure should then stay the same until the next MONDAY where the figure will change to display sales for the previous week.</P><P>Is this possible?</P></BODY></HTML> Fri, 18 Feb 2011 12:28:19 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306817#M1199990 hopkinsc 2011-02-18T12:28:19Z AW:Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306818#M1199991 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can use the datefunktion week() and with set analysis you get the sales of the week before</P></BODY></HTML> Fri, 18 Feb 2011 13:57:45 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306818#M1199991 brenner_martina 2011-02-18T13:57:45Z AW:Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306819#M1199992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can use Week(datefield) and with set analysis you get sales of the week before - pardon for entering it twice,</P></BODY></HTML> Fri, 18 Feb 2011 13:59:06 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306819#M1199992 brenner_martina 2011-02-18T13:59:06Z AW:Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306820#M1199993 <HTML><HEAD></HEAD><BODY><P>Ok thanks Martina, Do you have an example of the set analysis??</P></BODY></HTML> Fri, 18 Feb 2011 14:24:35 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/306820#M1199993 hopkinsc 2011-02-18T14:24:35Z