topic Set analysis Last Year to date in QlikView

Set analysis Last Year to date

Fri, 11 Nov 2011 17:13:44 GMT

I am running into some problems. I originally had a set analysis that was showing last years invoice amount. It was just requested to show last year to date, so for example today, it would show invoice amounts from 01/01/2010 to 11/11/2010.

Original Expression:

Sum({1<[Year Applied]={$(=Year(Today())-1)}>} [Invoice Amount])

I can not figure out how to tell it to take only the dates of last year <=Today

I Tried this with no success: ([Date Applied M/D] is formatted to 'MM/DD' in the script)

Sum({1<[Year Applied]={$(=Year(Today())-1)},

[Date Applied M/D]={"<=$(=Date(Today(),'MM/DD'))"}

>} [Invoice Amount])

Help?

Set analysis Last Year to date

Fri, 11 Nov 2011 17:34:17 GMT

Can you try the below with date format as MM/DD/YYYY in script:

[Date Applied M/D]={"<=$(=Date(AddMonths(Today(),-12),'MM/DD/YYYY'))"}

Regards,

Kiran.

Set analysis Last Year to date

Fri, 11 Nov 2011 18:04:12 GMT

That works perfectly, Thank you.

Set analysis Last Year to date

Sat, 12 Nov 2011 02:16:48 GMT

Is there a sample QVW of this?