topic Re: Fiscal Master Calendar Script Error ')' Expected in QlikView

Fiscal Master Calendar Script Error ')' Expected

Anonymous — Wed, 20 Jan 2016 17:07:25 GMT

Hi All,

I'm attempting to write a fiscal calendar and need a flag for previous and current year and month, but got stuck. I'm getting errors as commented in the below script. Does anybody have any suggestions or syntax changes to make this logic work?

NoConcatenate

tempFisc2: //one row table to feed variable values

LOAD

FiscalYear,

FiscalQuarter,

FiscalMonth

Resident tempFiscCal

Where CalendarDate = Date(Now()) //Today's Date >>> should it be Date(Today())?

;

LET v_RP_CFyr = peek('FiscalYear', 0, 'tempFisc2'); //should have a value of '2016', 1st (only) row of above

LET v_RP_CFQ = peek('FiscalQuarter', 0, 'tempFisc2');

LET v_RP_CFMo = peek('FiscalMonth', 0, 'tempFisc2');

NoConcatenate

FiscCal:

LOAD *,

FiscalMonth & '-' & FiscalYear as FiscalMonthYear,

if($(v_RP_CFyr) = FiscalYear, 1,0) as cFYr_Flag, //says ')' expected

if(peek('FiscalYear', 0, 'tempFisc2') = FiscalYear, 1, 0) as cFYr_Flag2 //tried this, returns 0 only

if(v_RP_CFyr = FiscalYear, 1,0) as cFYr_Flag3, //field not found (due to resident load)

Resident tempFiscCal;

DROP Table tempFiscCal, tempFisc2;

Re: Fiscal Master Calendar Script Error ')' Expected

israelcsouza — Wed, 20 Jan 2016 17:32:27 GMT

Hi Ron Payne,

Upload the QVW exemple.

Re: Fiscal Master Calendar Script Error ')' Expected

marcus_sommer — Wed, 20 Jan 2016 19:42:05 GMT

I think the reason is how you used the variables - if a variable contained a numeric value you could access them with $(var) and if they contained a string you need single-quotes around the variable like: '$(var)'

Here you find many useful links to fiscal calendar and flagging from periods and some more topics: How to use - Master-Calendar and Date-Values.

- Marcus

Re: Fiscal Master Calendar Script Error ')' Expected

Anonymous — Wed, 20 Jan 2016 19:50:16 GMT

Thanks, Marc. This was a good suggestion. I have forced my variable to num and changed WHERE... date(now()) to date(today()). I'm uploading the same qvw to show you how it works using the variables before the final load.