Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
incardonut
Contributor
Contributor

Text Box - Error in set modifier ad hoc element list: ',' or ')' expected in formula

Hey there,

I'm pretty stumped - I've checked to make sure that  the date formatting all lines up and the set analysis checks out (to my untrained eye).

Could you please help me fix the following set analysis? It gives me the error: 'Error in set modifier ad hoc element list: ',' or ')' expected in formula'.

Thank you,🙂
Erika

 

Set Analysis

=count({$<Fund_Date={$(vYestDate)}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={$(vYestDate)}>}Fund_AmountText),'$###,##0')

 

Formats for variables

date(Date#(makedate(year(Fund_DateTime),month(Fund_DateTime),day(Fund_DateTime)),'yyyy/mm/dd')) as Fund_Date

Let vYestDate = if(WeekDay(Today(0)) = 'Mon', Date(Today(0) - 3),if(WeekDay(Today(0)) = 'Sun', Date(Today(0) - 2), Date(Today(0) - 1)));

Labels (3)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

 

change your expression to below
=count({$<Fund_Date={'$(vYestDate)'}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={'$(vYestDate)'}>}Fund_AmountText),'$###,##0')

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

 

change your expression to below
=count({$<Fund_Date={'$(vYestDate)'}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={'$(vYestDate)'}>}Fund_AmountText),'$###,##0')

incardonut
Contributor
Contributor
Author

Thank you! 😊

dplr-rn
Partner - Master III
Partner - Master III

👍