YTD View given MTD View

Wed, 25 Apr 2012 13:25:41 GMT

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.

YTD View given MTD View

stevedark — Wed, 25 Apr 2012 13:40:23 GMT

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/

topic YTD View given MTD View in QlikView

YTD View given MTD View

YTD View given MTD View