topic Re: YTD from previous year in QlikView

YTD from previous year

Wed, 03 Sep 2014 13:30:53 GMT

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

Re: YTD from previous year

ashfaq_haseeb — Wed, 03 Sep 2014 13:34:34 GMT

Hi,

Have a look at below post.

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

Regards

ASHFAQ

Re: YTD from previous year

crusader_ — Wed, 03 Sep 2014 13:34:51 GMT

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

Re: YTD from previous year

MK_QSL — Wed, 03 Sep 2014 13:38:36 GMT

Sum({$<

Nature={'Actual},

[Fiscal Year]=,

month=,

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

Re: YTD from previous year

Wed, 03 Sep 2014 13:52:42 GMT

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

Re: YTD from previous year

Wed, 03 Sep 2014 13:53:17 GMT

I Shows only 0 and no values.

Can give me hint why?

Re: YTD from previous year

Wed, 03 Sep 2014 13:55:21 GMT

this code Show nothings no figure only a space.

Do you have a other question?

Re: YTD from previous year

MK_QSL — Wed, 03 Sep 2014 13:56:57 GMT

Yes, Provide sample data 🙂

Re: YTD from previous year

crusader_ — Wed, 03 Sep 2014 14:00:43 GMT

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)

Re: YTD from previous year

Wed, 03 Sep 2014 14:05:15 GMT

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

Re: YTD from previous year

MK_QSL — Wed, 03 Sep 2014 14:08:49 GMT

Sum({$<

Nature={'Actual},

[Fiscal Year]=,

month=,

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