Joining and filtering with the where clause

ClareChinonye — Tue, 09 Jan 2024 12:25:22 GMT

Hi,

I am very new to qlik sense, and i am currently struggling with Joining my tables and filtering with the where clause.

This is what my script looks like, and i keep getting an error can someone please help me out? thanks

LIB CONNECT TO 'MY_LIVE SFDC';

LOAD HistoryID,
AssetID,
StatusID,
SubStatusID,
ReasonID,
WorksOrder,
ProductionRate,
StartTime,
EndTime,
Username,
Comment;

[AssetStatusHistory]:
SELECT HistoryID,
AssetID,
StatusID,
SubStatusID,
ReasonID,
WorksOrder,
ProductionRate,
StartTime,
EndTime,
Username,
Comment
FROM SFDataCapture.dbo.AssetStatusHistory;

LOAD EventID,
Username,
WorksOrder,
StartTime,
EndTime,
HasHandover;

Left Join (AssetStatusHistory)

[ServiceEvent]:
SELECT EventID,
Username,
WorksOrder,
StartTime,
EndTime,
HasHandover
FROM SFDataCapture.dbo.ServiceEvent
WHERE SFDataCapture.dbo.ServiceEvent.StartTime >= SFDataCapture.dbo.AssetStatusHistory.StartTime
AND SFDataCapture.dbo.ServiceEvent.StartTime <= SFDataCapture.dbo.AssetStatusHistory.EndTime OR now();

Re: Joining and filtering with the where clause

steeefan — Tue, 09 Jan 2024 15:35:33 GMT

It's probably the OR now() part of your script. Please provide the exact error you are getting instead of just writing " getting an error".

topic Joining and filtering with the where clause in App Development

Joining and filtering with the where clause

Re: Joining and filtering with the where clause