YTD View given MTD View

[#1]

Community,

I have an issue.  Is there a way to caculate YTD based on selection of a month and year?  I want the current month and those prior to be selected.  Here is the working set analysis for giving me the selected month and selected year:

sum({ $<  balcode={'ACTUAL'},

LinkYear={$(=Only("CurrentDocumentYear"))},

LinkMonth=CurrentDocumentMonth,

={'RBIACCT'}

             >}PeriodTotal)

The CurrentDocumentYear, and CurrentDocumentMonth are the list box selectors.

[stevedark]

Hi Brandon,

I have uploaded a couple of date period comparison apps to SharedQlikViews, one of these may help you out:

http://community.qlik.com/qlikviews/1175

Regards,

Steve

http://www.quickintelligence.co.uk/