topic Re: Expression - correct or a bug? in QlikView

Expression - correct or a bug?

jrepucci15 — Fri, 31 Mar 2017 18:35:24 GMT

The below "Wrong" expression in a Sheet properties conditional show field evaluated as "OK".

I contend it should not have been shown as "OK". (Note the missing value that should have followed the > symbol)

Is this a bug or is it a valid expression?

If it is a valid expression, what value was used / would be used on the right side of the > symbol?

Wrong:=IF(Len(only({$< AD_ASLTabAccessUsers ={'$(=OSUser())'} >} AD_ASLTabAccessUsers)) > , 1, 0)

Right:=IF(Len(only({$< AD_ASLTabAccessUsers ={'$(=OSUser())'} >} AD_ASLTabAccessUsers)) > 0 ,1, 0)

This returns "error in expression", which I would expect.

=IF( 1 > , 0, 1)

John

QV v12.10 SR4

QV v11.20, SR9

Re: Expression - correct or a bug?

Anil_Babu_Samineni — Sat, 01 Apr 2017 09:11:07 GMT

Here, the main problem is even excel also. If your condition is not running the correct syntax it won't work. For your case, If(1> ??, 0,1) -- I am not sure whether the condition on any other tool like QV. Qlikview don't have capable to understand what does the value after > they need to sort. Atleast '' should be there then qlik and other software has that power.

Re: Expression - correct or a bug?

vinieme12 — Sat, 01 Apr 2017 09:26:06 GMT

But does the "Wrong" expression evaluate to anything ? i don't think it will

Most certainly a logical error when building the syntax check

Re: Expression - correct or a bug?

jrepucci15 — Sun, 02 Apr 2017 23:18:29 GMT

Vineeth,

The expression acted like it had no effect. It let everyone see that tab.

I agree with you - I think that expression demonstrates a bug in the Qlikview syntax check.