topic Script last 6 weeks in QlikView https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380260#M491538 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P></P><P>I want to show last 6 weeks values in my graph </P><P>My date dimension is =day(weekstart(Created))&amp;'-' &amp; day(weekend(Created)) &amp;' ' &amp; monthname(Created) </P><P>and my expression is =count(ID)</P><P></P><P>Thanks</P></BODY></HTML> Thu, 23 Aug 2012 08:42:45 GMT QSense 2012-08-23T08:42:45Z Script last 6 weeks https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380260#M491538 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P></P><P>I want to show last 6 weeks values in my graph </P><P>My date dimension is =day(weekstart(Created))&amp;'-' &amp; day(weekend(Created)) &amp;' ' &amp; monthname(Created) </P><P>and my expression is =count(ID)</P><P></P><P>Thanks</P></BODY></HTML> Thu, 23 Aug 2012 08:42:45 GMT https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380260#M491538 QSense 2012-08-23T08:42:45Z Re: Script last 6 weeks https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380261#M491539 <HTML><HEAD></HEAD><BODY><P>My date field (created) format is : dd.mm.yyyy hh:ss</P></BODY></HTML> Thu, 23 Aug 2012 08:54:43 GMT https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380261#M491539 QSense 2012-08-23T08:54:43Z Re: Script last 6 weeks https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380262#M491540 <HTML><HEAD></HEAD><BODY><P>it didnt work</P></BODY></HTML> Thu, 23 Aug 2012 09:34:28 GMT https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380262#M491540 QSense 2012-08-23T09:34:28Z Re: Script last 6 weeks https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380263#M491541 <HTML><HEAD></HEAD><BODY><P>use smth like count({&lt; Date = {'&gt;=$(=date(weekstart(Created)))&lt;=$(=date(weekend(Created)))'}&gt;}ID)</P></BODY></HTML> Thu, 23 Aug 2012 09:51:14 GMT https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380263#M491541 2012-08-23T09:51:14Z Re: Script last 6 weeks https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380264#M491542 <HTML><HEAD></HEAD><BODY><P>It gives all weeks </P></BODY></HTML> Thu, 23 Aug 2012 10:04:20 GMT https://community.qlik.com/t5/QlikView/Script-last-6-weeks/m-p/380264#M491542 QSense 2012-08-23T10:04:20Z