Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)
Thank you Sunny!