QlikView的产生没有数据(Qlikview no data generated)

我有一个左加入v_gate_pm_trip与v_fate_pm_trip_cntr一个事实表。我能够通过之日起的一个月名（到达）来生成QVD DT）howerver，当它加载*从居民实际上，没有数据被读取的所有月份。

FACT:
LOAD "TRIP_ID",
    "PM_M",
    "ARRIVE_DT",
    MonthName("ARRIVE_DT") as MONTH_NAME, //find out the monthname present in the data
SQL SELECT *
FROM EODWADMIN."V_GATE_PM_TRIP";

LEFT JOIN 

LOAD "TRIP_ID",
    "CREATE_DT",
    "MODIFIED_DT";
SQL SELECT *
FROM EODWADMIN."V_GATE_PM_TRIP_CNTR";

// Start looping through each distinct value in the Month field
for i = 1 to FieldValueCount('MONTH_NAME')
    // In-loop variable that will get the current increment value from the Month field
    let sMonhValue = FieldValue('MONTH_NAME', $(i));
    trace Storing data for MONTH_NAME --> $(sMonhValue);

    // NoConcatenate is used to tell Qlik to not concatenate the same tables
    NoConcatenate

    // Load the data for the current iteration month from the main data table
    TempTable:
    Load
      *
    Resident
      FACT
    where
      MONTH_NAME = $(i) order by ARRIVE_DT;

    // Store one month data in qvd. The name of the qvd will include the month value        
    Store TempTable into FACT_$(sMonhValue).qvd;

    // If the qvd files need to be stored somewhere else - just provide the path like:
    //Store TempTable into c:\users\UserName\Documents\RandData_$(sMonhValue).qvd;

    // Drop the temp table. Otherwise it will get concatenated to the "previos" temp table 
    Drop Table TempTable;
next

// At the end the app will contain only one table - `RandData`

Answer 1:

奇怪的事情有关 “通过ARRIVE_DT其中MONTH_NAME = $（i）可命令;” 部分。

$（我）是一个数字，从循环，你应该使用“其中MONTH_NAME =‘$（sMonhValue）’由ARRIVE_DT秩序;”？

Answer 2:

其中MONTH_NAME = '$（sMonhValue）'