YTD from previous year

[#1]

Hello togehter,

I have a YTD Formula (it Shows the right figures)

Sum({$<Nature={'Actual'},[Fiscal Year]=, month=, DateNum={">=$(Num(YearStart(Max(DateNum))))<=$(=(Max(DateNum)))"}>} Amount)

this formula Shows the wrong figures

Sum({$<Nature={'Actual},[Fiscal Year]=, month=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))>=$(=AddYear(max(DateNum), -1 ))"}>}Amount)

Do you know why? and could help me.

Thanks

[ashfaq_haseeb]

Hi,

Have a look at below post.

http://community.qlik.com/docs/DOC-7045

Regards

ASHFAQ

[crusader_]

Hi,

Smth wrong in your >= <= logic I suppose.

Sum({$<Nature={'Actual},[Fiscal Year]=, month=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))>=$(=AddYear(max(DateNum), -1 ))"}>}Amount)

Please check it.

Hope this helps.

Andrei

[MK_QSL]

Sum({$<

Nature={'Actual},

[Fiscal Year]=,

month=,

DateNum= {“$(=Num(YearStart(Max(DateNum)),-1))<=$(=AddYear(Max(DateNum),-1))”}Amount)

[#5]

This is the formula of this post with the Appendix Nature={'Actual'}

[#6]

I Shows only 0 and no values.

Can give me hint why?

[#7]

this code Show nothings no figure only a space.

Do you have a other question?

[MK_QSL]

Yes, Provide sample data 🙂

[crusader_ · Accepted solution]

Oh, Are you sure about AddYear function???

Try this

Sum({$<Nature={'Actual},[Fiscal Year]=, month=,

               DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))<=$(=Num(AddMonths(max(DateNum), -12 )))"}>}

          Amount)

[#10]

What do you mean with sample data? The structure of the table?