Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jayeshmule
New Contributor II

CrossTable loads data twice in the Qlikview / Sense

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.

1 Reply
jayeshmule
New Contributor II

Re: CrossTable loads data twice in the Qlikview / Sense

Any body can you please help?

Community Browser