Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
karabothari
Contributor II
Contributor II

Auto-generate Reload Error on QlikView 11

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.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful