Date filter in expression.

[#1]

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]))))

[sunny_talwar · Accepted solution]

May be some missing parenthesis:

What format is [Expense Month-Year]?

[Gysbert_Wassenaar]

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.