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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!