topic Re: Qlikview 11 for Developers issue in QlikView

Qlikview 11 for Developers issue

Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: Qlikview 11 for Developers issue

Digvijay_Singh — Thu, 09 Feb 2017 21:24:27 GMT

Did you reload the script after adding new tables?

Re: Qlikview 11 for Developers issue

vishsaggi — Thu, 09 Feb 2017 21:38:06 GMT

Do you have all the qvd files in the path mentioned?

Re: Qlikview 11 for Developers issue

Thu, 09 Feb 2017 21:41:52 GMT

Ok that helped me get 5 out of the 7 but I'm still missing Aircraft groups and Distance groups. Any thoughts? Thanks for the help.

Re: Qlikview 11 for Developers issue

Thu, 09 Feb 2017 21:44:51 GMT

I'm not sure what you mean. I'm very new and trying to work through this book by myself. I did what the last commenter said and reloaded the script but that only gave me 5 of the 7 tables. Still missing Aircraft groups and Distance groups.

Re: Qlikview 11 for Developers issue

vishsaggi — Thu, 09 Feb 2017 21:47:01 GMT

I mean the script when it runs, it is trying to access the qvd files from a path location. Like you mentioned.

[Aircraft Groups]:

LOAD [%Aircraft Group ID],

[Aircraft Group]

FROM

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

(qvd); -> This is the path where this QVD file is trying to read. So do you have that qvd file in this path?

Re: Qlikview 11 for Developers issue

Digvijay_Singh — Thu, 09 Feb 2017 21:50:49 GMT

Try reloading script again and check the execution progress window, it should show missing table name somewhere there and information of no of rows loaded, if not, then you might have problem in accessing those qvd files.

Re: Qlikview 11 for Developers issue

vishsaggi — Thu, 09 Feb 2017 21:54:03 GMT

Can you run the script in debug mode like open edit script and click on debug and keep clicking on step button and see if you find any rows not reading from the tables

Re: Qlikview 11 for Developers issue

Thu, 09 Feb 2017 22:13:57 GMT

I'm not sure how to check the execution progress window. The QVD files are from the website the book came from. Still not working.

Re: Qlikview 11 for Developers issue

Thu, 09 Feb 2017 22:15:00 GMT

There is nothing after (qvd); for any of the files but 5 of them worked and 2 didn't. Still can't figure it out.

Re: Qlikview 11 for Developers issue

Thu, 09 Feb 2017 22:16:35 GMT

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.

Re: Qlikview 11 for Developers issue

vishsaggi — Thu, 09 Feb 2017 22:29:50 GMT

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]

Re: Qlikview 11 for Developers issue

rwunderlich — Thu, 09 Feb 2017 23:50:53 GMT

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

-Rob

Re: Qlikview 11 for Developers issue

Anil_Babu_Samineni — Fri, 10 Feb 2017 01:52:24 GMT

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

Re: Qlikview 11 for Developers issue

Fri, 10 Feb 2017 16:52:58 GMT

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

Re: Qlikview 11 for Developers issue

Fri, 10 Feb 2017 16:53:27 GMT

No tables stuck behind.

Re: Qlikview 11 for Developers issue

rwunderlich — Fri, 10 Feb 2017 17:33:45 GMT

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

-Rob

Re: Qlikview 11 for Developers issue

Fri, 10 Feb 2017 17:37:13 GMT

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.

Re: Qlikview 11 for Developers issue

Fri, 10 Feb 2017 17:47:30 GMT

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

Re: Qlikview 11 for Developers issue

Fri, 10 Feb 2017 17:56:46 GMT

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.