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

If Statement in Macro Help

I am currently trying to add an if statement into some code in a macro design to send automated emails every day.  Currently the macros runs great except now I am being asked to have the emailed data go out for the previous month if the day of the month is less than or equal to 5.  Our company has a roll over date of 3 business days to get all data in for the prior month before closing the books. With the weekend this is where the 5 days works out perfectly.  My code in the macro is shown below.  I believe all variable are self explanatory but if not let me know and I can clarify.  When I type this code in the macro and hit ok I get an error message that is shown below.

1 Reply
m_woolf
Master II
Master II

Next time please post your code as text.

you have a quote in the parentheses that isn't closed.