topic count for last 6 weeks in QlikView

count for last 6 weeks

QSense — Thu, 23 Aug 2012 10:56:35 GMT

Hello ,

I want to show last 6 weeks values in my graph

My date dimension is =day(weekstart(Created))&'-' & day(weekend(Created)) &' ' & monthname(Created)

and my expression is =count(ID)

Thanks

Re: count for last 6 weeks

Thu, 23 Aug 2012 11:55:05 GMT

Use the follwoing script and Expression

let Last6Week=week(today())-6;

let TodayWeek=week(today());

count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)

Re: count for last 6 weeks

Thu, 23 Aug 2012 11:55:28 GMT

Use the follwoing script and Expression

let Last6Week=week(today())-6;

let TodayWeek=week(today());

count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)