topic Error in expression: ')' expected in QlikView

Error in expression: ')' expected

Fri, 03 Dec 2010 10:01:17 GMT

I'm using QV9 and when i want to reload appear: Error in expression: ')' expected

I was trying to discover the problem and finally i find it but i don't understand what's wrong.

The error appear when the file open and that moment use a macro with this script:

set v = ActiveDocument.Variables("BirthdayDate")
v.SetContent "=timestamp(today()+1,'DD/MM/YYYY')", true

if it works in a button, why that error message when open the document?

Thanks

Fri, 03 Dec 2010 10:15:33 GMT

Hi Fourth ,

In the Edit Module . In the lefthand side change the current local security to "Allow System Access" .

Hope this helps you.

Regards,

Chakravarthy.

Fri, 03 Dec 2010 10:17:26 GMT

Hi,

Can you try this one,

sub t
set v = ActiveDocument.GetVariable("Variable1")
v.SetContent "timestamp(today()+1,'DD/MM/YYYY')", true
End Sub

Regards,

Ravi

Fri, 03 Dec 2010 10:42:45 GMT

i was trying differents scripts and finally found one that works:

v = ActiveDocument.Evaluate("=date(today()+1,'DD/MM/YYYY')")
ActiveDocument.Variables("BirthdayDate").SetContent v, true

Thanks!