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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Establish closing month in script

Hi,

I'm going crazy not understanding what's wrong with my script so i need you guys, In my script i have the following statement:

if($(vCurrentDay)>=$(vCloseDate), $(vMonthToday), $(vPreviousMonth)) as ClosedMonth

Where the variables are as follows:

vCurrentDay = 4

vCloseDate = 8

vMonthToday = Mar 2014

vPreviousMonth = Feb 2014

The statment is in my calendar load. And when i run the script i get the error " ')' expected".

What am i missing? i have several if statements in the same load that works just fine.

//A.

1 Reply
maxgro
MVP
MVP

some ' missing?

if($(vCurrentDay)>=$(vCloseDate), '$(vMonthToday)', '$(vPreviousMonth)') as ClosedMonth