Variables in set expression

[Anonymous]

Hi all,

I'm converting this expression from QlikSense to QlikView:

=Sum({<AllocMktAllocMonth={">=$(=vMonthToday) <$(=vMonthToday+3)"}, AllocMktMillCd={'ATF','FIG','SET'}>}AllocMktAllocMake)-sum({<AllocMktAllocMonth={">=$(=vMonthToday) <$(=vMonthToday+3)"}, AllocMktMillCd={'ATF','FIG','SET'}>}AllocMktResvdMake)

Today, vMonthToday=3 so I wanted the table to display values from month 3 to month 5. This works fine in QlikSense but not on QlikView. In the QlikView it presents months 1,2,3,4 and 5...Does anyone know why?

Thank you!

[sunny_talwar · Accepted solution]

May be remove this space

=Sum({<AllocMktAllocMonth={">=$(=vMonthToday)<$(=vMonthToday+3)"}, AllocMktMillCd={'ATF','FIG','SET'}>}AllocMktAllocMake)-sum({<AllocMktAllocMonth={">=$(=vMonthToday)<$(=vMonthToday+3)"}, AllocMktMillCd={'ATF','FIG','SET'}>}AllocMktResvdMake)

[Anonymous]

Thank you Sunny!