topic Expression to show last week figures in QlikView https://community.qlik.com/t5/QlikView/Expression-to-show-last-week-figures/m-p/327975#M1196169 <HTML><HEAD></HEAD><BODY><P>Hi, i am trying to create a chart showing me the total waste by region for the last complete week.</P><P>I already have a last week field - CAL_LASTWEEK and my region field is BDANAME. It needs to be for a specific set of customers = RETAILGROUP and the retail group is OWN STORES and lastly it needs to show all waste, my waste field is [STORE STOCK MOVEMENT CODE] which has 20+ codes, i only want it to show codes 3, 5&nbsp; and 16.</P><P></P><P>So to summarise...</P><P></P><P>My fields are:</P><P>CAL_LASTWEEK</P><P>BDANAME</P><P>RETAILGROUP (which has several groups, i only want OWN STORES)</P><P>[STORE STOCK MOVEMENT CODE] (but the only codes i want are 3, 5 and 16.</P><P></P><P>Can anyone help please?</P></BODY></HTML> Tue, 28 Jun 2011 16:09:30 GMT hopkinsc 2011-06-28T16:09:30Z Expression to show last week figures https://community.qlik.com/t5/QlikView/Expression-to-show-last-week-figures/m-p/327975#M1196169 <HTML><HEAD></HEAD><BODY><P>Hi, i am trying to create a chart showing me the total waste by region for the last complete week.</P><P>I already have a last week field - CAL_LASTWEEK and my region field is BDANAME. It needs to be for a specific set of customers = RETAILGROUP and the retail group is OWN STORES and lastly it needs to show all waste, my waste field is [STORE STOCK MOVEMENT CODE] which has 20+ codes, i only want it to show codes 3, 5&nbsp; and 16.</P><P></P><P>So to summarise...</P><P></P><P>My fields are:</P><P>CAL_LASTWEEK</P><P>BDANAME</P><P>RETAILGROUP (which has several groups, i only want OWN STORES)</P><P>[STORE STOCK MOVEMENT CODE] (but the only codes i want are 3, 5 and 16.</P><P></P><P>Can anyone help please?</P></BODY></HTML> Tue, 28 Jun 2011 16:09:30 GMT https://community.qlik.com/t5/QlikView/Expression-to-show-last-week-figures/m-p/327975#M1196169 hopkinsc 2011-06-28T16:09:30Z Expression to show last week figures https://community.qlik.com/t5/QlikView/Expression-to-show-last-week-figures/m-p/327976#M1196170 <HTML><HEAD></HEAD><BODY><P>Morning everyone, any ideas on this?</P></BODY></HTML> Wed, 29 Jun 2011 08:25:12 GMT https://community.qlik.com/t5/QlikView/Expression-to-show-last-week-figures/m-p/327976#M1196170 hopkinsc 2011-06-29T08:25:12Z