topic Re: Script line error in Data values in QlikView

Script line error in Data values

Wed, 08 Mar 2017 16:20:03 GMT

Hi all,

I'm trying generate a calculation to present date/time values and i'm having this error:

//**

Tmp_dates:

LOAD DISTINCT

Date(42573,450208137 + RecNo() - 1) AS [Data]

AUTOGENERATE (42619,605902234 - 42573,450208137+1)

//**

The code is:

Temp:

LOAD

min([DInicio]) as minDate,

max([DFim]) as maxDate

RESIDENT tmp_f_ados;

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

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

DROP TABLE Temp;

Tmp_dates:

LOAD DISTINCT

Date($(varMinDate) + RecNo() - 1) AS [Data]

AUTOGENERATE ($(varMaxDate) - $(varMinDate)+1);

Have anyone any idea thats happing?

many thanks,

Re: Script line error in Data values

sunny_talwar — Wed, 08 Mar 2017 16:29:07 GMT

What exactly is the error?

Re: Script line error in Data values

Wed, 08 Mar 2017 16:30:31 GMT

IS this:

//**

Tmp_dates:

LOAD DISTINCT

Date(42573,450208137 + RecNo() - 1) AS [Data]

AUTOGENERATE (42619,605902234 - 42573,450208137+1)

//**

Re: Script line error in Data values

aarkay29 — Wed, 08 Mar 2017 16:31:53 GMT

One reason may be

42573,450208137 should be 42573.450208137

dot '.' instead of comma ',' there

Re: Script line error in Data values

sunny_talwar — Wed, 08 Mar 2017 16:34:13 GMT

May be give this a shot (single quotes around your variables)

Tmp_dates:

LOAD DISTINCT

Date('$(varMinDate)' + RecNo() - 1) AS [Data]

AUTOGENERATE ('$(varMaxDate)' - '$(varMinDate)'+1);

Re: Script line error in Data values

Wed, 08 Mar 2017 16:37:03 GMT

stalwar1‌,

Was the quotes.

Thanks