Stop calc at current year max week number

[#1]

Hello experts,

I want to compare data from two distinct years, but only to the latest week from the current year.

So if I have 9 weeks of data in the current year I want to stop the calculation at week 9 in each year.

I've attached a Qvw to explain more fully.

Hopefully this is self explanatory.

Cheers.

[sinanozdemir]

Hi Jeff,

Is this what you are looking for?

Calculation stops at week 9.

I am attaching the qvw as well.

Thanks

[maxgro · Accepted solution]

I think the expression for 2014/15 should be (look at the image)

sum({< FinYear = {'2014/15'}, FinWeek={"<=$(=(max({$ <FinYear={'$(=maxstring(FinYear))'}>} FinWeek)))"} >} Count)

Replace the same expression in the difference

[sunny_talwar]

May be this as your expression:

If(sum({< FinYear = {'2015/16'}>} Count) > 0, sum({< FinYear = {'2015/16'}>} Count) - sum({< FinYear = {'2014/15'}>} Count))

[sunny_talwar]

or this should also work:

If(Len(Trim(Avg({< FinYear = {'2015/16'}>} Count))) > 0, sum({< FinYear = {'2015/16'}>} Count) - sum({< FinYear = {'2014/15'}>} Count))

[#6]

Hi MaxGro - thanks for this very much appreciated - just what I was looking for.

[#7]

Thanks Sinan not quite the way I needed this time, thanks for the pointers in any case.

J.

[#8]

Thanks Sunny - both examples work - and the principles you employed will be helpful as I develop the overall dash.

Cheers

J.