Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Variables in set expression

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!

1 Solution

Accepted Solutions

May be remove this space

Capture.PNG

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



View solution in original post

2 Replies

May be remove this space

Capture.PNG

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



View solution in original post

Creator II
Creator II

Thank you Sunny!