Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Valued Contributor III

Error in expression

=sum({<Month={">=$(=Month(YearStart(GetFieldSelections(Year)))<=$(=GetFieldSelections(Month))"}>}ACTUALS_USD)

Please correct where i am going wrong , getting below error :

Error: Error in set modifier ad hoc element list:

',' or ')' expected

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Error in expression

You missed one close bracket

=sum({<Month={">=$(=Month(YearStart(GetFieldSelections(Year))))<=$(=GetFieldSelections(Month))"}>}ACTUALS_USD)

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)

View solution in original post

2 Replies
Highlighted

Re: Error in expression

Are you selecting just One Month and year at a time? Can you give an example of the selections you are making and what range of months should be shown by the expression

Highlighted

Re: Error in expression

You missed one close bracket

=sum({<Month={">=$(=Month(YearStart(GetFieldSelections(Year))))<=$(=GetFieldSelections(Month))"}>}ACTUALS_USD)

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)

View solution in original post