Display set of weeks on x axis

[#1]

Hey techies,

I am trying to display a set of last 26 weeks on x axis irrespective of its values, but if i take largest 26 weeks in dimension limits it takes weeks largest based on values, can someone please suggest me how to overcome this issue,

thanks.

[salto]

PFA.

[#3 · Accepted solution]

It seems looking fine let me check and apply this on my qvw file.

thanks

[#4]

Thanks,

it seems looking correct answer for me,

let me check it on my file,

[#5]

Hi There,

thanks for your help in resolving the issue but now there is some complications arise,

Its working fine with the weeks of same year but as year changes its not working.

please find attachment.

kindly suggest any logic or code to resolve this issue.

Thanks

[jagan]

Hi,

You need to arrive a date field in script and should use the set analysis expression

Data:

LOAD

     WeekNumber,

     Quantity,

     MakeWeekDate(Left(, 4), Num(Right(WeekNumber, 2))) AS Date

FROM DataSource;

Use weeknumber as dimension and use this expression

=Sum({<WeekNumber=, Date= {'>=$(=WeekStart(Max(Date), -25))<=$(=WeekEnd(Max(Date)))'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[#7]

Hi All,

Thanks for all your support,

This issue has been resolved using 'Autonumber()' to weeks based on which we can sort and take desired no of weeks.

Thanks a lot