# 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
Did you mean:
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
MVP

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)

2 Replies
MVP

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)

Creator II

Thank you Sunny!

Tags