Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD BUDGET calculation

Hi i have the following keys attaching budget to Sales - YearMonth

i have also budget year and month as dimensions on the budgettable.

i wish to create a YTD calculation for Budget but however have not been able to get it right.

see calculation below;

=SUM({<BudgetYear={'$(vMaxBudgetYear)'},Date2={'<=$(vMaxDate)'},Month=,Day=,[BudgetYearMonth]=>}BudgetSEK)

i have attached my document for further reference.

Budget value should be 23 M , not 84 (total).

Best

Brad

Labels (1)
0 Replies