Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD View given MTD View

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.

1 Reply
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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/