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

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

incardonut — Sat, 16 Nov 2024 20:13:27 GMT

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)));

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

dplr-rn — Wed, 21 Aug 2019 19:38:06 GMT

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

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

incardonut — Wed, 21 Aug 2019 19:45:13 GMT

Thank you! 😊

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

dplr-rn — Wed, 21 Aug 2019 19:54:50 GMT

👍