Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
sofiavaz
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
sunny_talwar

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
sunny_talwar

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

sofiavaz
Creator II
Creator II

Thank you Sunny!