Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends...
I have the following SQL Server Query and need to interpret it in Qlik Sense Script... I need you help, thanks a lot in advance, waiting for your comments...
WITH SUMATORIA AS (SELECT SUM(AMOUNT) AS IMPORTE, ACCNT_CODE, ANAL_T2, PERIOD
FROM [IAD_MexicoSEMU].[dbo].[W11_A_SALFLDG]
GROUP BY ACCNT_CODE, ANAL_T2, PERIOD)
SELECT ACCNT_CODE, ANAL_T2, PERIOD, IMPORTE FROM SUMATORIA;
Greetings...
Hi, in such a way.
SUMATORIA:
LOAD ACCNT_CODE,
ANAL_T2,
PERIOD,
Sum(AMOUNT) as IMPORTE
Resident [IAD_MexicoSEMU].[dbo].[W11_A_SALFLDG]
Group By ACCNT_CODE, ANAL_T2, PERIOD;
/*---Optionally, drop the original table if not needed---*/
Drop Table [IAD_MexicoSEMU].[dbo].[W11_A_SALFLDG];
Thank you @BrunPierre I will try this