Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We know that sometimes the expression editor syntax checker displays red squiggle lines in an expression that does not have a true error. It may be caused by an error in the syntax checker itself or the use of variables where the syntax checker may not be expected to understand. For example:
=FirstSortedValue(DISTINCT, Price, Date)
DISTINCT will be flagged even though DISTINCT is documented as being valid.
=Sum ({<$(s.ClearSubmitter),Function={If}>}#FunctionCount)
The comma will be flagged even though there will be a valid expression after variable substitution.
In SR10 and prior the edit status message in the upper left corner will be "Expression OK". So we can know the error is with the syntax checker, not the actual expression.
In SR11, the status message has changed. If there is any red squiggle, the status message now reads "Errors in expression". This means I can no longer say "ignore the squiggle if it says 'Expression OK'".
So where's the bug now, the squiggles or the "Errors in Expression" message?
Hi Rob,
Unfortunately this is true and I don't know why QlikView can't understand its own syntax.
But the improvement I saw was with the use of the -= in Set Analysis. This syntax is now correctly recognized by the Syntax checker and has no red squiggles anymore.