topic Re: Stop calc at current year max week number in QlikView

Stop calc at current year max week number

Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 29 Mar 2016 18:16:55 GMT

Hi Jeff,

Is this what you are looking for?

Calculation stops at week 9.

I am attaching the qvw as well.

Thanks

maxgro — Tue, 29 Mar 2016 18:50:52 GMT

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 — Wed, 30 Mar 2016 02:26:43 GMT

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 — Wed, 30 Mar 2016 02:28:07 GMT

or this should also work:

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

Thu, 31 Mar 2016 07:31:40 GMT

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

Thu, 31 Mar 2016 07:32:44 GMT

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

Thu, 31 Mar 2016 07:34:15 GMT

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

Cheers