Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Error in set modifier ad hoc element list

Hello,

I am trying to add a yellow highlighted set expression to limit the headcount measure to the one at the last date as a default, and making it flexibly adjust the time from the selection of different dates in other visualizations.  While I used [Year] for the field in the yellow highlighted set expression, no error message appears, but when I replace it with the actual field [Data Copy], I get an incomprehensive error message saying "error in set modifier ad hoc element list: ',' or ')' expected".  

Newbie7_1-1632052729977.png

I'd appreciate it if anyone could let me know how I can clear this error message.  

 

Thank you & best regards,

 

 

1 Solution

Accepted Solutions
MarcoWedel

maybe it's the missing single quotes:

{$<[Date Copy]={'$(=max([Date Copy]))'}>}

hope this helps
Marco

View solution in original post

2 Replies
MarcoWedel

maybe it's the missing single quotes:

{$<[Date Copy]={'$(=max([Date Copy]))'}>}

hope this helps
Marco

Newbie777
Partner - Creator III
Partner - Creator III
Author

Thanks a lot Marco.  The error disappeared and set expression is now working perfectly!