topic Re: Variables in set expression in QlikView

Variables in set expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Variables in set expression

sunny_talwar — Wed, 14 Mar 2018 15:04:08 GMT

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)

Re: Variables in set expression

Anonymous — Wed, 14 Mar 2018 15:25:18 GMT

Thank you Sunny!