topic Previous 20 weeks in QlikView

Previous 20 weeks

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Need a line chart giving me the results of last 20 weeks. Now I already achieved this with my months for a 3,6,12 month chart but can't seem to figure out how it works for the weeks.

This expression gives me the last 4 months and works when I got 2016 = Feb 16, Jan 16, Dec 15, Nov 15

=sum({<Week=, MonthName=, Year=, DivisionName = {***'} + {'****'}, PerformanceDate ={">=$(=MonthStart(AddMonths(Today(),-4)))<$(=MonthEnd(Today()))"}>} Production.DurationHrs)

Count({<Week=, MonthName=, Year=, DivisionName = {****'} + {****'}, PerformanceDate ={">=$(=MonthStart(AddMonths(Today(),-4)))<$(=MonthEnd(Today()))"}>} Production.Name)*5

Kind regards

Vincent

Re: Previous 20 weeks

Digvijay_Singh — Wed, 09 Mar 2016 11:41:02 GMT

Similar to monthstart we have Weekstart, try with that

WeekStart(date [, period_no])

Re: Previous 20 weeks

Kushal_Chawda — Wed, 09 Mar 2016 11:44:16 GMT

try thid

=sum({<Week=, MonthName=, Year=, DivisionName = {***'} + {'****'}, PerformanceDate ={">=$(=date(Today()-140))<=$(=date(Today()))"}>} Production.DurationHrs)

Count({<Week=, MonthName=, Year=, DivisionName = {****'} + {****'}, PerformanceDate ={">=$(=date(Today()-140))<=$(=date(Today()))"}>} Production.Name)*5