Discussion board where members can get started with Qlik Sense.
I am attempting to join a table with some new information at the group level not the granular level.
I am using left join and have managed to get the data in but it is not behaving as expected.
Result with code
LIB CONNECT TO 'SLA TotalCount SiT';
FROM JSON (wrap on) "root"
QUERY "FromDate" "$(vFromDate)",
QUERY "ToDate" "$(vToDate)"
LEFT JOIN ([SLA Detail])
Date(Date#(Left([businessDate],10), 'YYYY-MM-DD'), 'YYYYMMDD') AS [Date],
[reportName] as [Report],
[containerName] AS [ContainerName],
sum([totalCount]) AS [Total Count FeedID],
'Source' AS [System]
RESIDENT RestConnectorMasterTable group by Date(Date#(Left([businessDate],10), 'YYYY-MM-DD'), 'YYYYMMDD'), containerName, reportName;
[Count Table]: NoConcatenate
Resident [SLA Detail];
Drop Table [SLA Detail];
Rename Table [Count Table] to [SLA Detail];
Drop Field [ContainerName] From [SLA Detail];
DROP TABLE RestConnectorMasterTable;