Discussion Board for collaboration on QlikView Scripting.
Busy with chapter 7 (P220) and having problems to load the script under aircraft tab as indicated below:
When I load the script in a new .qvw file it loads, my model for chapter 7 fails to load.
What am I doing wrong?
LOAD AC_TYPEID as [%Aircraft Type ID],
AC_GROUP as [%Aircraft Group Type],
SSD_NAME as [Aircraft Name],
MANUFACTURER as [Aircraft Manufacturer],
LONG_NAME as [Arcraft Name Full],
SHORT_NAME as [Aircraft Name Abbreviated],
BEGIN_DATE as [Aircraft Begin Date],
END_DATE as [Aircraft End Date]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
LOAD [Aircraft Group ID] as [%Aircraft Group Type],
[Aircraft Engine Type],
[Aircraft Number Of Engines]
I should achieve the following results as per handbook
When commenting out above script and replace with original script my data loads correctly
LOAD [%Aircraft Group ID],
[..\Data Files\QVDs\Aircraft Groups.qvd]
LOAD [%Aircraft Type ID],
[..\Data Files\QVDs\Aircraft Types.qvd]
Check the Table viewer and confirm first
Sorry, Please try generatig the script by Tables option provided by Qlik in edit script
I am using the edit script tool when creating this script, I cannot view the table due to load error on script and you are prompted to load old data. Any other suggestions?
Still no solution found
I had the same problem.
After I removed the two listboxes Aircraft Group and Aircraft Type in the Reports tab, the reload worked normally without the script error.
It might be necessary to remove them also from the other tabs. (They need to be removed in the next steps of the course anyway).