topic Re: Last YTD calculation issues. in QlikView

Last YTD calculation issues.

Fri, 31 Jul 2015 20:48:09 GMT

I currently have YTD & Last YTD working fine.

For Last YTD - I have all details through the year. However, on YTD - I am always a month behind.

For Example - today is July 31st. But I don't have any numbers yet for the current year.

So - my YTD is showing Jan1 - June 30th.

And Last YTD is showing Jan1 - July 31.

How do I get Last YTD to only calculate to the latest YTD Date I have?

Thanks

Amanda

sunny_talwar — Fri, 31 Jul 2015 21:27:19 GMT

How are you calculating your Last YTD? Is it done in the script or on the front end using set analysis???

maximiliano_vel — Sat, 01 Aug 2015 02:01:46 GMT

If you have a master calendar that the last date is June 30/2015 the you could have 4 variables

vMaxYear = Year(Max(Date));

vMaxDate = Max(Date); //Should be June 30/2015

vPrevYear = Year(AddYears(Max(Date), -1))

vMaxDatePrevYear = AddYears($(vMaxDate), -1) //Should calculate to June 30/2014

Then your formula should be something like

LYTD = Sum({<Year={$(vPrevYear)}, Date={"<=$(vMaxDatePrevYear)"}>} Sales) //Accumulated figures up to June 30/2014

YTD = Sum({<Year={$(vMaxYear)}, Date={"<=$(vMaxDate)"}>} Sales) //Accumulated figures up to June 30/2015

Mon, 03 Aug 2015 14:12:42 GMT

I am on hold for a couple days...because now I need to put July data in there to test your variables/formula.

I am assuming the variables go into the script?

maximiliano_vel — Mon, 03 Aug 2015 15:56:39 GMT

You have to create the variables in Settings->Variable Overview... or (Ctrl + Alt + V)

Regards

Fri, 21 Aug 2015 18:32:16 GMT

Sorry this took so long.... But this isn't working.

Using the varibles and the formual above, I only get '-'

Wed, 09 Dec 2015 19:09:36 GMT

Took me forever to get time to work on this project again. But your answer above was the key!

Thanks