Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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