topic Re: Date filter in expression. in QlikView

Date filter in expression.

Fri, 26 Feb 2016 15:27:07 GMT

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

Re: Date filter in expression.

sunny_talwar — Fri, 26 Feb 2016 15:29:11 GMT

May be some missing parenthesis:

What format is [Expense Month-Year]?

Re: Date filter in expression.

Gysbert_Wassenaar — Fri, 26 Feb 2016 15:30:19 GMT

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.