Analytics SAQL Developer Guide
j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
Handle Null Dates
Use is not null to filter out null
dates.
q = filter q by 'CloseDate' is not null;
q = foreach q generate 'CloseDate';Projecting null values does not cause an error. For example, this Date Closed field is empty, but no error occurs.
q = filter q by year('CloseDate') is null;
q = foreach q generate year('CloseDate') as "Date Closed";