Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

count for last 6 weeks

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

2 Replies
Not applicable

Re: count for last 6 weeks

Use the follwoing script and Expression

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

let TodayWeek=week(today());

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

Not applicable

Re: count for last 6 weeks

Use the follwoing script and Expression

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

let TodayWeek=week(today());

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

Community Browser