evaluate() fails when it has already failed for a prior column of a record

[gussfish]

OS: Windows XP 2002 SP  2

PC: Intel Core2 Duo, P9400 @ 2.4GHz, 3.45 GB

QV: QlikView for Windows 10.00.8811.6.SR1

First, the example for evaluate() in the Reference Manual, is pointless, since it calls evaluate on a numeric (i.e. evaluate(5*8) ) rather than on a string (i.e. evaluate('5*8') ).

The main defect, though, is that is evaluate() fails while processing an input record, then a call to evaluate within the context of the same record also fails.

RawData:
LOAD * INLINE [
    InlineName, InlineValue, ArbitraryValue
    FortyInlineRecord, 5*8, 3
 TextInlineRecord, random text, 1
];
 
EvaluationsBoth:
LOAD 
 InlineName AS Both.Name,
 evaluate(InlineValue) AS Both.EvaluatedInlineValue,
 evaluate('5*8') As Both.AlwaysFortyColumn, // this fails if the previous evaluate() fails
 ArbitraryValue AS Both.ArbitraryValue
resident RawData;

See attached QVW for the above code & UI.

[s_uhlig]

I can confirm this bug on 10.00.8935.7 SR2 64-bit

[gussfish · Accepted solution]

"

Dear Angus

Your recent support case as described below has been confirmed by our QA department as a bug, ID 38854.

...

Wallace Chen

Service Desk Analyst JAPAC

Email: support@qlik.com

qlik.com

ref:00D2IGPX.500DEyG3T:ref

"