Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
Qlik Sense: Issue when creating a calculated field from Data Manager
Article Number: 000062532 | Last Modified: 2019/01/24Description
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:
Environement:
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
Environement:
- Qlik Sense Desktop
- Qlik Sense Enterprise
Resolution
Known issue, bug QLIK-93152.
This bug was closed by R&D as WAD (working as designed) with below explanation:
This bug was closed by R&D as WAD (working as designed) with below explanation:
"Calculated field expressions do not support AND / OR. It's not a bug, just not part of the subset that's supported there.
This could be changed to an improvement if we want to implement it at some point, but it's beyond a bug fix".
This could be changed to an improvement if we want to implement it at some point, but it's beyond a bug fix".
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.