topic Re: Error: Week takes 1 parameter in QlikView

Error: Week takes 1 parameter

cristian_av — Wed, 22 Aug 2018 13:46:20 GMT

I'm reloading a script in QV Desktop without any problem.

But when it reloads in QV Server, it throws the following error:

.....

22-08-2018 10:41:47: 0991 Week(%Fecha,0,0) As SemanaZarpe,

22-08-2018 10:41:47: 0992 WeekName(%Fecha) as SemanaAñoZarpe

22-08-2018 10:41:47: Error: Error in expression:

22-08-2018 10:41:47: Week takes 1 parameter

....

According to the QV documentation, the week function has two parameters. I can clear the parameters, but the function will give me unwanted results.

Am I doing something wrong?

Thanks!!

m_woolf — Wed, 22 Aug 2018 13:53:58 GMT

What is the value of %Fecha when the error occurs?

cristian_av — Wed, 22 Aug 2018 13:56:54 GMT

No matter what value is, I've tested with 0,1, 42000 and others... with any number the error occurs.

According to this, the error is because of the version 11 only supports one parameter, and version 12 supports 4 parameters.

But.. how do I get an equivalent of the Week(%Fecha,0,0) with one parameters..?

ValeriyaBartosh — Wed, 22 Aug 2018 13:58:43 GMT

Hello, you can try use variables except parameters

week(timestamp [, first_week_day [, broken_weeks [, reference_day]]])

Set BrokenWeeks=0; //(use unbroken weeks)

Set BrokenWeeks=1; //(use broken weeks)

SET FirstWeekDay=0;

SET FirstWeekDay=1;

BalaBhaskar_Qlik — Wed, 22 Aug 2018 14:07:21 GMT

It's better to post some of the script pertains week() and data screenshots.

cristian_av — Wed, 22 Aug 2018 15:13:38 GMT

The problem was QV Version.

Finally I solved following this guide: