Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.