Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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.