Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jrepucci15
Contributor

Expression - correct or a bug?

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

Tags (1)
3 Replies

Re: Expression - correct or a bug?

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.

Life is so rich, and we need to respect to the life !!!
vinieme12
Esteemed Contributor II

Re: Expression - correct or a bug?

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

Most certainly a logical error when building the syntax check

jrepucci15
Contributor

Re: Expression - correct or a bug?

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.

Community Browser