Reload issue with more feilds in load statement???

[#1]

Hi ALL,

Is there any limit to load the number of feilds into the QV script?

As in my case i have more than 20 fields and its not at all loading also.

Could anyone please help me giving any suggestions?

Is this the limitation in QV?

Thanks,

Mahasweta

[#2]

I personally have applications with well over 100 calculated dimensions (fields), so I know it's not an issue with QlikView's treatment of quantity of fields. Please upload your qvw (or a reduced copy) so we can have a look. Thanks!

[#3]

Hi,

This is my script.once i am reloading its not at all loading (it took minimum 20 minutes,so i stopped)

Absorption:

LOAD "DATE_ID",
Year(DATE_ID) as Year,
'Q ' & Ceil(Month(DATE_ID)/3) as Quarter,
Month(DATE_ID) as Month,
Date(Monthstart(DATE_ID), 'MMM-YYYY') as MonthYear,
'Q' & Ceil(Month(DATE_ID)/3) & ' - ' & Year(DATE_ID) as QuarterYear,
1 AS ABSORPTIONBYPERIOD,
0 AS CUMULATIVEABSORPTION,
0 AS CUMULATIVEPRODUCTION,
0 AS CUMULATIVEDELIVERIES,
0 AS CUMULATIVEDELIVERIESQTY,
0 AS PURCHASINGBYMATERIAL,
0 AS PURCHASINGBYLOCATION,
0 AS PURCHASINGBYLOCATIONQTY,
0 AS CAPACITYUTILIZATION,
0 AS CAPACITYOFFER,
0 AS PLANTCAPACITY,
0 AS MPSBYLOCATION,
0 AS INVENTORYBREAKOUT,
0 AS INVENTORYBYLOCANDMATERIAL,
0 AS INVENTORYRMSOPERATIVE,
0 AS DEMANDANDRMS,
0 AS PRODUCTIONDEMAND,
0 AS SUMMARYKPI,
"LOCATION_NAME",
"LOCATION_NUM",
"PRODUCT_NAME",
PNO,
SUPPLIER_NUM,
0 AS SCENARIO_NUM,
'' AS SCENARIO_NAME,
"PRODUCT_API",
"PRODUCT_FAMILY",
"ACTUAL_HOURS_CBMH",
"ACTUAL_PRODUCTION",
"PLANNED_PRODUCTION",
"ACTUAL_ABSORPTION",
"PLAN_ABSORPTION",
"BUDGET_ABSORPTION",
"BUDGET_PRODUCTION";
SQL SELECT *
FROM ABSORPTION_VW;


Purchasing:
LOAD "DATE_ID",
Year(DATE_ID) as Year,
'Q ' & Ceil(Month(DATE_ID)/3) as Quarter,
Month(DATE_ID) as Month,
Date(Monthstart(DATE_ID), 'MMM-YYYY') as MonthYear,
'Q' & Ceil(Month(DATE_ID)/3) & ' - ' & Year(DATE_ID) as QuarterYear,
0 AS ABSORPTIONBYPERIOD,
0 AS CUMULATIVEABSORPTION,
0 AS CUMULATIVEPRODUCTION,
0 AS CUMULATIVEDELIVERIES,
0 AS CUMULATIVEDELIVERIESQTY,
1 AS PURCHASINGBYMATERIAL,
0 AS PURCHASINGBYLOCATION,
0 AS PURCHASINGBYLOCATIONQTY,
0 AS CAPACITYUTILIZATION,
0 AS CAPACITYOFFER,
0 AS PLANTCAPACITY,
0 AS MPSBYLOCATION,
0 AS INVENTORYBREAKOUT,
0 AS INVENTORYBYLOCANDMATERIAL,
0 AS INVENTORYRMSOPERATIVE,
0 AS DEMANDANDRMS,
0 AS PRODUCTIONDEMAND,
0 AS SUMMARYKPI,
"LOCATION_NAME",
"LOCATION_NUM",
PNO,
"SUPPLIER_NUM",
0 AS SCENARIO_NUM,
'' AS SCENARIO_NAME,
PRODUCT as PRODUCT_NAME,
API as PRODUCT_API,
"PRODUCT_FAMILY",
"SUPPLIER_NAME",
"ACTUAL_PURCHASED",
"FIRM_PURCHASE_ORDERS",
"PURCHASE_QTY",
"PURCHASE_COST",
"PURCHASING_COST";
SQL SELECT *
FROM PURCHASING_VW;

Please help me.

Thanks,

Mahasweta

[#4]

Hi ,

You can have a look here.

One note please : i have section access here also.

What i can see here the data is loading but the SYn keys are not getting(i mean the SYn key formation is taking time i hope)

Could you please put some thought into this?

Thanks,

Mahasweta

[#5]

Mahasweta,

Looking at that script, it looks like you have a ton of synthetic keys, which could be causing loops. One idea would be to concatenate these tables to prevent this. See this thread: http://community.qlik.com/forums/p/16217/63137.aspx, or search for synthetic keys.