New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this solution

george55
Partner - Creator III
Partner - Creator III

It worked! The solution was to initiate and end with "'" and using a concat

 

="'" &
Concat(Distinct
FirstWorkDate($(=Max(Floor(FieldX ))), 5, $(Holiday))
, ';')
& "'"

 

View solution in original post

Who Me Too'd this solution