Skip to main content

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!

Qlik Sense: Issue when creating a calculated field from Data Manager

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Musekura
Support

Qlik Sense: Issue when creating a calculated field from Data Manager

Last Update:

Aug 24, 2020 9:42:03 AM

Updated By:

Sonja_Bauernfeind

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:

  1. Adding () to define a new grouping does not solve the issue
  2.  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.

Labels (1)