

Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense: Issue when creating a calculated field from Data Manager
Last Update:
Aug 24, 2020 9:42:03 AM
Updated By:
Created date:
Jan 17, 2019 11:37:45 AM
When defining a "calculated field" in Data Manager, an error is being thrown despite that used formula syntax is correct (see below formula):
If(
MonthEnd([Entry Date]) >
MonthEnd([Posting Date]) And [Fiscal Year] = 2018,
'Late','OK')
Note:
- Adding () to define a new grouping does not solve the issue
- Remove the part "And [Fiscal Year] = 2018" and/or add () in the condition part works in some versions
Resolution:
This has been recorded at Qlik with the internal ID QLIK-93152 and deemed working as designed.
Calculated field expressions do not support AND / OR. It's not a bug, just not part of the subset that's supported there.
333 Views