YTD Calculation

[#1]

H all,

i want to calculate a YTD of year that i select.

For example if i select 2016-02 i want a sum of value of 2016-01 and 2016-02 etc...

Like field I have year_month (eg. YYYY-MM)

Can somebody help me?

[ziadm]

Hi Cecilia

use this set analysis

set vMaxYear = Max(Year)

Set vMaxDate =date(max(Date), 'DD MMM YYYY')

sum({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}Qta)

Thanks

[sunny_talwar]

Did you get time to look at my response here -> Re: Prior year for year_month field

[ziadm]

of Follow the following thread

QlikView App: Simple Year To Date Example (Set Analysis)

[satishkurra]

Check the attached

[#6]

Hi Satish, if we use a text object the solution works, but i would see the value 350 in the following table, below the date 02/01/2016, but it doesn't appear .

What can i do?

Thanks

[satishkurra]

Hi

I understand u have done this using pivot table. Now  go to presentation tab and select Date dimension and check show partial sum option. Now you can see total

Let me know 

[#8]

I Satish, i explain you better what I would. I attach a qvw with the pivot table in which I want below 02/01/2016 the value 350, below 03/01/2016 the value 700 and so on…. Like a progressive values…

I hope I have explain my issue better.

[satishkurra]

I don't think we can achieve this...

[sunny_talwar]

Why not Satish? Try this:

=RangeSum(Before(Sum({$<Date={">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}[Sales]) , 0, ColumnNo()))