Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in expression: ')' expected

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

3 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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!