Qlikview no data generated

2019-08-20 06:50发布

I have a fact table that left join v_gate_pm_trip with v_fate_pm_trip_cntr. I was able to generate the qvd by by the month name of the date (arrive)dt) howerver, when it load * from resident fact, no data is being fetch for all month.

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`

2条回答
beautiful°
2楼-- · 2019-08-20 07:00

Where MONTH_NAME = '$(sMonhValue)'

查看更多
够拽才男人
3楼-- · 2019-08-20 07:06

Something strange about the "where MONTH_NAME = $(i) order by ARRIVE_DT;" part.

$(i) is a number, from the loop, should you be using "where MONTH_NAME = '$(sMonhValue )' order by ARRIVE_DT;"?

查看更多
登录 后发表回答