topic YTD for last year in QlikView

YTD for last year

Tue, 26 Feb 2013 10:52:17 GMT

Hi All,

I am struggling to find a solution to show me YTD values for the last fiscal year and was hoping that someone could help..

My current expression is ..

=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)}>}[Sales Amount GBP])

that just gives me the total sales for the last fiscal year, i want it to look at this years current week number but apply that to the set analysis to show from week 1 to the current week last year.. if that makes sense..

my week field is :

Op_Week

Can anyone help?

Many thanks

Re: YTD for last year

manideep78 — Tue, 26 Feb 2013 11:15:13 GMT

Could you please provide some samle data???

Re: YTD for last year

alexandros17 — Tue, 26 Feb 2013 11:15:42 GMT

let vCurrWeek= week(today())

=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)},

Op_Week={'>=1<=$(vCurrWeek)'}

>}[Sales Amount GBP])

Hope it helps

Re: YTD for last year

manideep78 — Tue, 26 Feb 2013 11:44:08 GMT

Try this

Sum({<[Fiscal Year]={"$(=Max([Fiscal Year])-1)"},Op_Week={">=1<=$(=Week(Today()))"}>}[Sales Amount GBP])

Hope it helps