Below is the script which I am loading with some modification on data from SQL Server. But the data is loaded twice in Qlikview or Qliksense. Please guide on this.
[Defects]:
CrossTable([DateCol], [DefectState], 22)
LOAD
[DefectID],
[ReleaseID] AS [ReleaseId],
[Application] AS [Defects.Application],
[Summary],
[Description],
[Severity],
[Status],
Date(LEFT([CreatedDate], 10)) as [CreatedDate],
Date(MonthStart([CreatedDate]), 'MMM-YYYY') as DefectCreatedMonthYear,
Date(Left([CreatedDate],10), 'DD-MMM') as DefectCreatedMonthDay,
Date(LEFT([CloseDate], 10)) as [CloseDate],
Date(MonthStart([CloseDate]), 'MMM-YYYY') as DefectClosedMonthYear,
Date(Left([CloseDate],10), 'DD-MMM') as DefectClosedMonthDay,
[RootCause],
[Module],
[OpenCount],
[CloseCount],
[Aging],
Interval( if(IsNull([CloseDate]), Today(), [CloseDate]) - [CreatedDate], 'd') AS [DefectAging],
If
(
Interval(if (IsNull([CloseDate]), Today(), [CloseDate]) - CreatedDate, 'd') <= 3,
'<=3 days',
if(
Interval(if (IsNull([CloseDate]), Today(), [CloseDate]) - CreatedDate, 'd') <= 6,
'>3<=6 days',
if(
Interval(if (IsNull([CloseDate]), Today(), [CloseDate]) - CreatedDate, 'd') <= 10,
'>6<=10 days',
'>10 days'
)
)
) AS AgingCategory,
[AssignedTo],
[DetectedBy],
Date(MonthStart([CreatedDate]), 'MMM-YYYY') as DefectCreated,
Date(MonthStart([CloseDate]), 'MMM-YYYY') as DefectClosed;
SQL SELECT *
FROM Defects;
Please help data is loading twice with this statement.
