Auto-generate Reload Error on QlikView 11

karabothari — Wed, 12 Apr 2017 11:47:00 GMT

Good Day all,
Still finding my way with Qlik and I am getting the below error when trying to reload my application.

Below is an extract of a log file,

Firstly thought its a source issue as they might be null values in one of my tables but reload is still failing so i need a few pointers on where to look.

'TP029-7' As [PROMOTION_KEY],

Num(Date(Date#(20170415,'YYYYMMDD') + RowNo() -1 - 0,'YYYYMMDD')) As [EVENT_DATE],

Date(Date#(20170415,'YYYYMMDD') + RowNo() -1 - 0,'YYYYMMDD') As [EVENT_DATE_ORIG],

'E' As [EVENT_DATE_TYPE]

AutoGenerate (zPromoDuration + 1)Information 2017/04/12 13:16:53: Error: Script line error:

General Script Error

Execution Failed

Execution finished.

Re: Auto-generate Reload Error on QlikView 11

Anil_Babu_Samineni — Wed, 12 Apr 2017 14:18:26 GMT

What does it is? zPromoDuration

Is that is variable or simple Field. If variable you can make as

Autogenerate $(zPromoDuration )+1;

It will work till all values from zPromoDuration + 1

topic Re: Auto-generate Reload Error on QlikView 11 in QlikView

Auto-generate Reload Error on QlikView 11

Re: Auto-generate Reload Error on QlikView 11