Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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