Sorting in Line Chart

[hopkinsc]

Hi All,

i am trying to get a line chart sorted as per the following..

i have week number on my x axis which is currently sorted numerically (1-52) but what i want is to sort it based on the last date that data was received.

The last date is 09/10/2017 which is week 41, so i want the chart to start at week 42 and end at 41.

can anyone help please?

i have attached an example.

Thanks

[sunny_talwar]

Try sorting by Max(Date) (Asc or Desc)

[Anil_Babu_Samineni]

May be use Calc. Dimension for Week like

=If(Week >= $(vMaxEndDate), Week)

[hopkinsc]

this is the first thing i tried (and the obvious one) but it doesnt work in my live qvw!

this might be difficult for me get help with then as i cant upload my live version.

i see it works in my sample though..

[sunny_talwar]

What is different between this sample and live version? Set Analysis? calculated dimension? anything else?

[hopkinsc]

No calculated dimensions and no set analysis. the only difference is the data model.

there are some synthetic keys which i will sort out now but up until now they've caused no problems.

maybe its those that are stopping this from working

[sunny_talwar]

Very difficult to say....

[hopkinsc]

no worries, thanks for your help, i will sort out these synthetic keys and try again.

[hopkinsc]

i have managed to get an example where its not working.

any chance you could see if anything jumps out? !

[sunny_talwar · Accepted solution]

Try this

=Max({<MAT_Year = {'Current Year (MAT)'}>}nd_CALENDAR_YYYYMMDD)