Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Both of these expressions are not working for me.Can anybody help me please
=Sum({<[Expense Month-Year] ={">=$(=MonthStart(Today())) <= $(=MonthEnd(Today(), 12))"}>}
Aggr(Max({<[Expense Month-Year] ={">=$(=MonthStart(Today()) )<= $(=MonthEnd(Today(), 12))"}>}
[Amount of Expense]*12),%SubspaceKey,[Expense Type]))
=sum(
IF([Expense Month-Year] >= MonthStart(Today()) ,
IF([Expense Month-Year] <= MonthEnd(Today(), 12),
Aggr(Max([Amount of Expense]*12),%SubspaceKey,[Expense Type]))))
May be some missing parenthesis:
What format is [Expense Month-Year]?
Make sure that Expense Month-Year has the same date format as the default date format of your document. If you need more help then please post a small qlikview document that demonstrates the problem.