Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
toddbuss
Creator
Creator

syntax issue in set analysis

Can anyone tell me why this set analysis works:

Count( {$<ReportDate={"$(=(Max(ReportDate)))"}>*<[Inpatient Bed]={"Inpatient"}>}[Bed ID])

and this one doesn't?:

Count( {$<ReportDate={"$(=(Max(ReportDate)-3))"}>*<[Inpatient Bed]={"Inpatient"}>}[Bed ID])

The Qlik syntax is a necessary evil...but very evil.

Thanks.

10 Replies
toddbuss
Creator
Creator
Author

Thanks to all.

After toying with the formula for a bit, I discovered that the problem on my end was the date format has to be:  'MM,DD,YYYY' .  Everything is working now.