Qlikview 11 for Developers issue

[#1]

Hi,

I'm John and I recently purchased this book to learn how to use Qlikview. I ran into an issue. In chapter 2 page 40-42 it wants you to structure the script a certain way to add multiple tabs and tables. Below is the five tabs I have altogether and the script for each of these tables. When I hit control T to bring up the table viewer it's supposed to look like the picture on page 42. But I don't have any connectors. It's just the Main Data tab.  Can someone help?

Main tab

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Main Data tab

[Main Data]:

LOAD [%Airline ID],

     [%Carrier Group ID],

     [%Unique Carrier Code],

     [%Unique Carrier Entity Code],

     [%Region Code],

     [%Origin Airport ID],

     [%Origin Airport Sequence ID],

     [%Origin Airport Market ID],

     [%Origin World Area Code],

     [%Destination Airport ID],

     [%Destination Airport Sequence ID],

     [%Destination Airport Market ID],

     [%Destination World Area Code],

     [%Aircraft Group ID],

     [%Aircraft Type ID],

     [%Aircraft Configuration ID],

     [%Distance Group ID],

     [%Service Class ID],

     [%Datasource ID],

     [# Departures Scheduled],

     [# Departures Performed],

     [# Payload],

     Distance,

     [# Available Seats],

     [# Transported Passengers],

     [# Transported Freight],

     [# Transported Mail],

     [# Ramp-To-Ramp Time],

     [# Air Time],

     [Unique Carrier],

     [Carrier Code],

     [Carrier Name],

     [Origin Airport Code],

     [Origin City],

     [Origin State Code],

     [Origin State FIPS],

     [Origin State],

     [Origin Country Code],

     [Origin Country],

     [Destination Airport Code],

     [Destination City],

     [Destination State Code],

     [Destination State FIPS],

     [Destination State],

     [Destination Country Code],

     [Destination Country],

     Year,

     Period,

     Quarter,

     [Month (#)],

     Month,

     [From - To Airport Code],

     [From - To Airport ID],

     [From - To City],

     [From - To State Code],

     [From - To State]

FROM

[..\Data Files\QVDs\Flight Data.qvd]

(qvd);

Airlines tab

[Carrier Groups]:

LOAD [%Aircraft Group ID],

     [Aircraft Group]

FROM

[..\Data Files\QVDs\Aircraft Groups.qvd]

(qvd);

[Carrier Operating Region]:

LOAD [%Region Code],

     [Carrier's Operating Region]

FROM

[..\Data Files\QVDs\Carrier Operating Region.qvd]

(qvd);

[Flight Types]:

LOAD [%Datasource ID],

     [Flight Type]

FROM

[..\Data Files\QVDs\Flight Types.qvd]

(qvd);

Aircrafts tab

[Aircraft Groups]:

LOAD [%Aircraft Group ID],

     [Aircraft Group]

FROM

[..\Data Files\QVDs\Aircraft Groups.qvd]

(qvd);

[Aircraft Types]:

LOAD [%Aircraft Type ID],

     [Aircraft Type]

FROM

[..\Data Files\QVDs\Aircraft Types.qvd]

(qvd);

Airports tab

[Distance Groups]:

LOAD [%Distance Group ID],

     [Distance Interval]

FROM

[..\Data Files\QVDs\Distance Groups.qvd]

(qvd);

[#2]

Trying that but not sure what I'm looking for. Sorry. Very new to this. I followed instructions from book exactly but can't get it to work.

[vishsaggi]

Can you check the path and send us the screen shot of what files you see.

Do you see Aircraft Groups.qvd and

Aircraft Types.qvd files in the path give below.

Like here

[..\Data Files\QVDs\Aircraft Groups.qvd]

[..\Data Files\QVDs\Aircraft Types.qvd]

[rwunderlich]

Your script looks ok. Have you tried dragging the tables around in the Table Viewer to see if there are tables stuck behind?

-Rob

[Anil_Babu_Samineni]

Script looks Good. What was the error you are facing over there. Can you show the Error snaps for us it illustrates the issue

[#6]

I don't know if this is what you're looking for.

[#7]

No tables stuck behind.

[rwunderlich]

Can you create a Document Log (page 248 of the book) and upload here?

-Rob

[#9]

No that's my problem is they are not showing up when I do control T. The script seems to be correct based on what everyone else has said. The tables are not there when I do control T.

[#10]

I followed the instructions on 248 (Saving logs to disk) but don't know where to find it.

[#11]

I might have been over my head thinking I could teach myself this. I was doing fine until this problem came up and now I can't get it fixed and can't continue unless I do.