tableDA:
LOAD
DA_Organisation,
DA_NumeroDA,
FKEY_NumeroDA,
DA_TypeSolution,
DA_SousCategorie,
Year([DA_DateOuverture]) & '-' & Month([DA_DateOuverture]) as DA_YearMonth,
Year([DA_DateOuverture]) & '-' & Month([DA_DateOuverture]) as JOIN_YearMonth
FROM \\s3i600\QlikView\DA.qvd (qvd)
WHERE LEFT(DA_TypeSolution,4) = '123' AND (DA_Organisation = 'XYZ' OR DA_Organisation = 'ABC');
//------------------------------------
tableACT:
LOAD
ACT_Organisation,
ACT_NumeroActivite,
FKEY_NumeroDA,
ACT_Type,
ACT_Motif,
ACT_DateDebutReel,
Year([ACT_DateDebutReel]) & '-' & Month([ACT_DateDebutReel]) as ACT_YearMonth,
Year([ACT_DateDebutReel]) & '-' & Month([ACT_DateDebutReel]) as JOIN_YearMonth
FROM \\s3i600\QlikView\Activites.qvd (qvd)
WHERE ACT_Type = 'Appel entrant';
//------------------------------------
tableCLIENT:
LOAD
CLI_NumeroContrat,
CLI_DateActivationRedbox,
Year([CLI_DateActivation]) & '-' & Month([CLI_DateActivation]) as CLI_YearMonth,
Year([CLI_DateActivation]) & '-' & Month([CLI_DateActivation]) as JOIN_YearMonth
FROM \\s3i600\QlikView\Clients.qvd (qvd)
WHERE CLI_Etat = 'A';
//------------------------------------
RecapDA:
LOAD
count (DA_NumeroDA) as [Nombre de DA],
JOIN_YearMonth
RESIDENT tableDA
GROUP BY JOIN_YearMonth;
//------------------------------------
RecapACT:
LOAD
count (ACT_NumeroActivite) as [Nombre d'appels],
JOIN_YearMonth
RESIDENT tableACT
GROUP BY JOIN_YearMonth;
//------------------------------------
RecapCLIENT:
LOAD
count (CLI_NumeroContrat) as [Nombre de clients],
JOIN_YearMonth
RESIDENT tableCLIENT
GROUP BY JOIN_YearMonth;
Partager