topic Re: Rolling week in QlikView

Rolling week

amilafdo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create a bar chart for last 12 weeks. Can any one support me to create this.

Thanks

Amila

Re: Rolling week

Anil_Babu_Samineni — Mon, 17 Apr 2017 08:22:10 GMT

May be this, I assume you already have week field with you

Sum({$<Week={">=$(=Max(Week)-11)<=$(=Max(Week))"}>} Sales)

Re: Rolling week

amilafdo — Mon, 17 Apr 2017 08:55:50 GMT

Hi Anil,

Thanks for your feedback. What i need is as below it need to come last 12 weeks.

Re: Rolling week

Anonymous — Mon, 17 Apr 2017 09:04:14 GMT

Alter Anil's expression with your fields

Week with your Financial week field

Sales with your Machine break down,

For Bars

Sum({$<Week={">=$(=Max(Week)-11)<=$(=Max(Week))"}>} Sales).

Are you expecting the expression for 3W Moving average too?? try something like below

RangeAvg(Above(Avg({<Week=>} Sales), 0, 3)) * Avg({<Week={">= $(=Max(Weeknum)-11) <=$(=Max(Weeknum)-11)"}>} 1)

Re: Rolling week

Anil_Babu_Samineni — Mon, 17 Apr 2017 09:10:04 GMT

12 weeks is the same, What are you expecting for whole object. Would you describe more

Re: Rolling week

amilafdo — Mon, 17 Apr 2017 09:13:03 GMT

Hi Shiva,

Thanks. My expression is Sum({$<[FINANCIAL WEEK]={">=$(=Max([FINANCIAL WEEK)-11)<=$(=Max([FINANCIAL WEEK))"}>} [Setup Time]) but it is not showing last 12 weeks. It show all the selected week.

Re: Rolling week

Anonymous — Mon, 17 Apr 2017 09:15:29 GMT

Try this, Sum({$<[FINANCIAL WEEK]=, Your month field =,[FINANCIAL WEEK]={">=$(=Max([FINANCIAL WEEK)-11)<=$(=Max([FINANCIAL WEEK))"}>} [Setup Time])

Re: Rolling week

amilafdo — Mon, 17 Apr 2017 09:19:09 GMT

Hi Anil,

I want to have continuous week.

eg: My financial year finsh on 31st March 2017. I want to have 12 weeks trend. ( After 2016-2017 weeks, it need to continue to 2017-2018 weeks. ...., 2016-2017 week 51, 2016-2017 week 52, 2017-2018 week 1, 2017-2018 week 2).

I think this is more clear.

Thanks

Amila

Re: Rolling week

amilafdo — Mon, 17 Apr 2017 09:26:04 GMT

Hi Shiva,

Not showing last 12 weeks it is same as earlier (It show all the selected week)

Re: Rolling week

Anonymous — Mon, 17 Apr 2017 09:27:54 GMT

Can you share a sample??

Re: Rolling week

amilafdo — Mon, 17 Apr 2017 09:33:52 GMT

Hi Shiva,

Original file in our server. What I need to have continue week (week no: 50, 51, 52, 1, 2 ... - 1 & 2 is next year)

eg: My financial year finish on 31st March 2017. I want to have 12 weeks trend. ( After 2016-2017 weeks, it need to continue to 2017-2018 weeks. ...., 2016-2017 week 51, 2016-2017 week 52, 2017-2018 week 1, 2017-2018 week 2).

I think this will be more clear.

Re: Rolling week

Anonymous — Mon, 17 Apr 2017 09:48:06 GMT

You want next 12 weeks or last 12 weeks form the selected week???

Re: Rolling week

tresB — Mon, 17 Apr 2017 11:35:12 GMT

Create a filed in the script to generate Week Sequence, may be like:

AutoNumber(Week&Year) as WeekSeq

And then use front-end expression like :

Sum({<Year, Month,WeekSeq={">$(=Max(WeekSeq)-12) <=$(=Max(WeekSeq))"}>}Data)