Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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)));

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

 

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
dilipranjith
Partner
Partner

 

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

incardonut
Contributor
Contributor
Author

Thank you! 😊

dilipranjith
Partner
Partner

👍