Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Broly
Contributor III
Contributor III

Different result from expected same expression

Hi guys,

here is the script which I am using:

LoadPerf:
load Distinct
SHIPMENT_ID,
if((A_MDE_LOADING_FINISHED = 0) and LASTACTION_DATA_SOURCE = 'MDE',
(num(A_LOADING_CLOSE_TIME) - MinLoadTimeUG ),
(num(A_MDE_LOADING_FINISH_TIME) - MinLoadTimeUG )) as ClosingTime

resident temp;

Broly_0-1606401058357.png

 

as you can see the last expression is valid, and the one before it is not.

Do you know why is that?

 

0 Replies