Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
JASalinas
Creator
Creator

Query SQL Server to Qlik Sense

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...

Labels (3)
2 Replies
BrunPierre
Partner - Master
Partner - Master

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];

 

JASalinas
Creator
Creator
Author

Thank you @BrunPierre I will try this