topic Re: Comparison between current week day and previous week day in QlikView https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443333#M165249 <HTML><HEAD></HEAD><BODY><P>Suppose you have a field MyDate that contains a date and Sales that contains sales amounts. If you select a date then sum(Sales) will return the sum of the sales for that day. Then sum({&lt;Mydate={'$(=only(MyDate)-7)'}&gt;}Sales) will return the sales of a week (7 days) earlier.</P></BODY></HTML> Sun, 17 Feb 2013 16:04:40 GMT Gysbert_Wassenaar 2013-02-17T16:04:40Z Comparison between current week day and previous week day https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443332#M165248 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P></P><P>I want </P><P>Comparison between current week day and previous week day.</P><P>Means if i select current monday then i want current mondays data with respective previous monday.</P><P></P><P>how can calculate it.</P><P></P><P>Regards,</P><P></P><P>Vishal</P></BODY></HTML> Sun, 17 Feb 2013 15:49:08 GMT https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443332#M165248 VishalWaghole 2013-02-17T15:49:08Z Re: Comparison between current week day and previous week day https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443333#M165249 <HTML><HEAD></HEAD><BODY><P>Suppose you have a field MyDate that contains a date and Sales that contains sales amounts. If you select a date then sum(Sales) will return the sum of the sales for that day. Then sum({&lt;Mydate={'$(=only(MyDate)-7)'}&gt;}Sales) will return the sales of a week (7 days) earlier.</P></BODY></HTML> Sun, 17 Feb 2013 16:04:40 GMT https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443333#M165249 Gysbert_Wassenaar 2013-02-17T16:04:40Z Re: Comparison between current week day and previous week day https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443334#M165250 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert</P></BODY></HTML> Mon, 18 Feb 2013 11:35:48 GMT https://community.qlik.com/t5/QlikView/Comparison-between-current-week-day-and-previous-week-day/m-p/443334#M165250 VishalWaghole 2013-02-18T11:35:48Z