Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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;
What is the value of %Fecha when the error occurs?
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..?
week() with more than 1 parameter generates script error in qlikview 11
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;
It's better to post some of the script pertains week() and data screenshots.