Help, How do i load distinct trade IDS

Fri, 03 May 2013 16:32:06 GMT

Hello,

I'm new to Qlikvew and i have to fix count issues for existing MI, we have several charts with multiple dimensions and so trying to use an expression to count distinct trade IDs doesn't work, i want to use load distinct but not sure how. Can somone help?

For each vTEST_PROD_FileName in FileList('$(vTEST_PROD_Fails_Folder)')

TEST_PROD_FAILS_DATA:
LOAD TEST_PROD_FAILS_MARKET,
     TEST_PROD_FAILS_TRADE_DATE,
     TEST_PROD_FAILS_SETT_DATE,
     TEST_PROD_FAILS_AGE,
     TEST_PROD_FAILS_OUR_REF,
     TEST_PROD_FAILS_NAME_OF_CLIENT_BROKER,
     TEST_PROD_FAILS_NAME_OF_STOCK,
     TEST_PROD_FAILS_BUY_SELL_CLIENT_PPSTVE,
     TEST_PROD_FAILS_CCY,
     TEST_PROD_FAILS_SETTLEMENT_AMT,
     TEST_PROD_FAILS_QUANTITY,
     TEST_PROD_FAILS_REASONS_FOR_FAILED_TRADE,
     TEST_PROD_FAILS_REMARKS,
     TEST_PROD_FAILS_MODE,
     TEST_PROD_FAILS_REPORT_YEAR,
     TEST_PROD_FAILS_REPORT_MONTH,
     TEST_PROD_FAILS_REPORT_MONTH&' '&TEST_PROD_FAILS_REPORT_YEAR AS TEST_PROD_FAILS_REPORT_MONTH_YEAR,
     IF(MATCH(TEST_PROD_FAILS_REPORT_MONTH,'Jan','Feb','Mar'),'Q1',IF(MATCH(TEST_PROD_FAILS_REPORT_MONTH,'Apr','May','Jun'),'Q2',
     IF(MATCH(TEST_PROD_FAILS_REPORT_MONTH,'Jul','Aug','Sep'),'Q3',IF(MATCH(TEST_PROD_FAILS_REPORT_MONTH,'Oct','Nov','Dec'),'Q4','')))) AS TEST_PROD_FAILS_REPORT_QUARTER,


FROM
[$(vTEST_PROD_FileName)]
(qvd);

Thanks

topic Help, How do i load distinct trade IDS in QlikView

Help, How do i load distinct trade IDS