Shwoing > 1 year data in qlikview

[deepakqlikview_123]

For showing 1 year data I am using below expression

Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver)

But for showing remaining month > 1 year can you please suggest what would be the expression

Thanks

[Anonymous]

Try

Sum({<AR_CustomerLedger.MonthYear ={"<$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver)

[Anil_Babu_Samineni]

But for showing remaining month > 1 year can you please suggest what would be the expression

I didn't follow on this?

[deepakqlikview_123]

mean all renmaining month year except previous 12 months.

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sum({<AR_CustomerLedger.MonthYear ={"*"}-{">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver)