topic Re: script error in QlikView

script error

vireshkolagimat — Thu, 14 Sep 2017 12:07:16 GMT

Hi All,

Could you please let me know what is wrong in the below script. When i execute the below script, getting below error message.

Error in expression:

Year takes 1 parameter

[InvExp Calendar]:

LOAD DISTINCT

Temp_Date as ExpiryDate,

MonthStart(Temp_Date) as ExpiryMnthDate,

Year(Temp_Date) as [InvExpYear],

Month(Temp_Date) as [InvExpMonth],

Month(Temp_Date)&'-'&Date(Temp_Date, 'YY') as [InvExpMonthName],

num(Month(DATE(Temp_Date,'DD/MM/YYYY'))) as [InvExpMonthNumber],

Date(Temp_Date, 'YYYY-MM') as [InvExpiryMonth],

((Year(Temp_Date) - Year($(vExpStartDate)))*12) + Num(Month(Temp_Date)) as InvExpRollingMonth;

LOAD DISTINCT

($(vExpStartDate) + IterNo() - 1) as Temp_Date

AUTOGENERATE (1)

WHILE $(vExpStartDate) + IterNo() - 1 <= $(vExpEndDate);

Thank you.

Regards,

Viresh

Re: script error

m_woolf — Thu, 14 Sep 2017 12:10:27 GMT

What is the contents of vExpStartDate?

Re: script error

Peter_Cammaert — Thu, 14 Sep 2017 12:11:14 GMT

Probably one of your variables that are used in $-sign expansion, in reality expands to ... nothing. You know, this error can mean that you either specify too many or too few parameters for the Year() function.

Check the spelling of your variables, and if they check out fine, check their content.

Re: script error

vireshkolagimat — Thu, 14 Sep 2017 12:12:07 GMT

It is showing as <Null>

Re: script error

Peter_Cammaert — Thu, 14 Sep 2017 12:17:05 GMT

There you have it. The code won't work if you do not enter acceptable values in variables vExpStartDate and vExpEndDate.

To test it out, you an create these variables in Settings->Variable Overview and supply values for them.