Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have completed all the steps on p. 424 of Qlikview 11 for Devs. See the code below.
I created a Table Box called Test (see its properties in the attached screen shots)
Yet # Delta Total Employees column only contains 0s (see Test_table.png attached)
May I ask you how this can be rectified.
thanks 
Transform - Employment Data.qvw:
In Main tab I have:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='DD-MM-YY';
SET TimestampFormat='DD-MM-YY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
In Initial Load:
Temp_Employment:
LOAD [%Airline ID],
[%Unique Carrier Code],
[%Carrier Group ID],
[# Full Time Employees],
[# Part Time Employees],
[# Total Employees],
[# Equivalent FTEs],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
Year,
Period,
[Month (#)],
Month
FROM
[..\3.QVD\Source\T_F41SCHEDULE_P1A_EMP.qvd]
(qvd);
In Transformation:
Employment:
Load
If([%Airline ID] = Peek('Airline ID', -1),[# Total Employees] - Peek('# Total Employees', -1),0) as [# Delta Total Employees],
[%Airline ID],
Year,
[Month (#)],
[# Total Employees],
Period,
Month,
[%Unique Carrier Code],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[%Carrier Group ID],
[# Full Time Employees],
[# Part Time Employees],
[# Equivalent FTEs]
Resident Temp_Employment
Order By [%Airline ID], Year, [Month (#)];
Drop Table Temp_Employment;
