Proceeding Load Not working

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to create some formulas on my data table using the proceeding load but it doesn't seem to work - help? Suggestions

DATA2:

Load

[Title_UK],

IF(ISNULL([Title_UK]) OR LEN(trim([Title_UK] ))=0 OR [Title_UK] =0, Title_US,

IF(ISNULL([Title_US]) OR LEN(trim([Title_US]))=0 OR [Title_US]=0, Title_FR,

IF(ISNULL([Title_FR]) OR LEN(trim([Title_FR]))=0 OR [Title_FR]=0, Title_ESP,

IF(ISNULL([Title_ESP]) OR LEN(trim([Title_ESP]))=0 OR [Title_ESP]=0, Title_NZ,

IF(ISNULL([Title_NZ]) OR LEN(trim([Title_NZ]))=0 OR [Title_NZ]=0, Title_GER,

IF(ISNULL([Title_GER]) OR LEN(trim([Title_GER]))=0 OR [Title_GER]=0, Title_ITA,

IF(ISNULL([Title_ITA]) OR LEN(trim([Title_ITA]))=0 OR [Title_ITA]=0, Title_AUS))))))) AS "Title_Filter",

[Release_Date_UK],

IF(ISNULL([Release_Date_UK]) OR LEN(trim([Release_Date_UK] ))=0 OR [Release_Date_UK] =0, Release_Date_US,

IF(ISNULL([Release_Date_US]) OR LEN(trim([Release_Date_US]))=0 OR [Release_Date_US]=0, Release_Date_FR,

IF(ISNULL([Release_Date_FR]) OR LEN(trim([Release_Date_FR]))=0 OR [Release_Date_FR]=0, Release_Date_ESP,

IF(ISNULL([Release_Date_ESP]) OR LEN(trim([Release_Date_ESP]))=0 OR [Release_Date_ESP]=0, Release_Date_NZ,

IF(ISNULL([Release_Date_NZ]) OR LEN(trim([Release_Date_NZ]))=0 OR [Release_Date_NZ]=0, Release_Date_GER,

IF(ISNULL([Release_Date_GER]) OR LEN(trim([Release_Date_GER]))=0 OR [Release_Date_GER]=0, Release_Date_ITA,

IF(ISNULL([Release_Date_ITA]) OR LEN(trim([Release_Date_ITA]))=0 OR [Release_Date_ITA]=0, Release_Date_AUS))))))) AS "Release Date_Filter",

[WW_IBOE],

IF(ISNULL([WW_IBOE]) OR LEN(trim([WW_IBOE] ))=0 OR [WW_IBOE] =0, IBOE_UK,

IF(ISNULL([IBOE_UK]) OR LEN(trim([IBOE_UK] ))=0 OR [IBOE_UK] =0, IBOE_US,

IF(ISNULL([IBOE_US]) OR LEN(trim([IBOE_US]))=0 OR [IBOE_US]=0, IBOE_FR,

IF(ISNULL([IBOE_FR]) OR LEN(trim([IBOE_FR]))=0 OR [IBOE_FR]=0, IBOE_GER,

IF(ISNULL([IBOE_GER]) OR LEN(trim([IBOE_GER]))=0 OR [IBOE_GER]=0, IBOE_ITA ))))) AS "IBOE_Filter"

;

Load

//SUM (Count(( "US_Cume Gross $") )) AS "total US Cume",

num(Sum("UK_Cume Gross $") + Sum("WW_International Cume Gross")) as "$_WW",

num(SUM ("UK_Cume Gross $") + SUM ("FR_Cume Adm") + SUM ( "GER_Cume Adm") + SUM ("NZ_Cume Gross $") + SUM ( "AUS_Cume Gross $")) AS "$ SC Total"

;

Load

[Title_UK], Title_US, Title_FR, Title_ESP, Title_NZ, Title_GER, Title_ITA, Title_AUS,

"Booking_Number" ,

[Release_Date_UK], Release_Date_US, Release_Date_FR, Release_Date_ESP, Release_Date_NZ, Release_Date_GER, Release_Date_ITA, Release_Date_AUS,

//"Release Date" ,

"$ Budget",

//"$_WW",

//[$ INT],

"WW_International Cume Gross",

//"$ SC Total",

"UK_Cume Gross $" ,

"US_Cume Gross $" ,

"FR_Cume Adm" ,

"GER_Cume Adm",

[WW_IBOE],[IBOE_UK], IBOE_US, IBOE_FR, IBOE_GER, IBOE_ITA,

"$ GER",

"ITA_Cume Adm",

"$ ITA",

"$_ESP",

//"ESP_Cume Gross $" ,

"AUS_Cume Gross $" ,

"NZ_Cume Gross $"

Resident DATA;

Drop table DATA;

topic Proceeding Load Not working in QlikView

Proceeding Load Not working