Master Calendar - Field Not Found

vdcastro — Tue, 19 Jul 2016 13:45:11 GMT

Hello guys,

i have a weird problem. I am developing an application.

I developed it in QlikView Desktop and it's ok.

Now i want to put it on QlikView Server. When i reload my application on QlikView Server it fails. I receive this error on the log:

2016-07-19 14:26:44 0395 LOAD

2016-07-19 14:26:44 0396 Date() + Iterno()-1 As TempDate

2016-07-19 14:26:44 0397

2016-07-19 14:26:44 0398 AutoGenerate 1 While + IterNo() -1 <=

2016-07-19 14:26:44 Error: Error in expression:

2016-07-19 14:26:44 Date takes 1-2 parameters

So i tried to find the problem and i detected it on my MasterCalendar:

Temp:

Load

min(%Data) as minDate,

max(%Data) as maxDate

Resident Cartas;

Let varMinDate = floor(Num(Peek('minDate', 0, 'Temp')));

Let varMaxDate = floor(Num(Peek('maxDate', 0, 'Temp')));

drop table Temp;

TempCalendar:

LOAD

$(varMinDate) + Iterno()-1 As TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar:

NoConcatenate

Load

Distinct

TempDate as %Data,

Date(TempDate) as Data.Data,

Year(TempDate) as Data.Ano,

Month(TempDate) as Data.Mes,

Monthname(TempDate) as Data.AnoMes,

WeekName(TempDate) as Data.AnoSemana,

'T' & ceil(month(TempDate) / 3) as Data.Trimestre,

num(Day(TempDate),'00') as Data.Dia,

WeekDay(TempDate) as Data.DiaSemana,

Week(TempDate) as Data.SemanaNum

// if(WeekDay(TempDate)='Sábado' or WeekDay(TempDate)='Domingo',0,1) as Data.Work_Day

Resident TempCalendar;

Let varMinDate = null();

Let varMaxDate = null();

Is it normal the same code run without problems on QlikView Desktop and fail on QlikView Server?

Can someone helps me?

Greetings

Re: Master Calendar - Field Not Found

swuehl — Tue, 19 Jul 2016 19:24:10 GMT

It's not normal, but it can happen that the same script returns different results on different servers.

I assume that your regional settings are different on both servers and that your date field %Data is interpreted differently in both environments:

Temp:

Load

min(%Data) as minDate,

max(%Data) as maxDate

Resident Cartas;

Check the outcome of the Temp table, I assume your fields won't show numbers.

If so, check your %Data field in your Cartas table, if it's interpreted corretly as date field, showing a numeric representation.

Why don’t my dates work?

topic Master Calendar - Field Not Found in QlikView

Master Calendar - Field Not Found

Re: Master Calendar - Field Not Found