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);
NEXT
Thanks