Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Set analysis expression

I have the below expression  and it doesn't work.Any help is appreciated.

=sum({<[Expense Month-Year]={'$(>=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

             [Subspace Commence]={'$(< addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

Thank you very much.

3 Replies
Chanty4u
MVP
MVP

try this


=sum({<[Expense Month-Year]={'>=$(=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

             [Subspace Commence]={'<$(= addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

sunny_talwar

Incorrect syntax, try this:

=Sum({<[Expense Month-Year] = {"$(='>=' & MonthName(Today()) & '<=' & MonthName(AddMonths(Today(),11)))"}, [Subspace Commence] = {"$(='<' & Date(AddMonths(Today(), 12), 'MM/DD/YYYY'))"}>} Finalamount)

Not sure if this will work, but the syntax should be better with the above expression

Anil_Babu_Samineni

Try this?

=Sum({<[Expense Month-Year] = {"$(='>=' & MonthName(Today()) & '<=' & MonthName(AddMonths(Today(),11)))"}, [Subspace Commence] = {"$(='<' & Date(AddMonths(Today(), 12), 'MM/DD/YYYY'))"}>} Finalamount)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)