Solved: Re: Error: Week takes 1 parameter - Qlik Community

cristian_av · ‎2018-08-22

Hi

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!!

ValeriyaBartosh · ‎2018-08-22

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;

m_woolf · ‎2018-08-22

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

cristian_av · ‎2018-08-22

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 · ‎2018-08-22

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;

balabhaskarqlik · ‎2018-08-22

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

cristian_av · ‎2018-08-22

The problem was QV Version.

Finally I solved following this guide: