4 Replies Latest reply: Sep 12, 2014 7:11 AM by Varsha Shashidhar RSS

    Applymap

      Hi All,

       

      I have used the below code. Applymap is not working for me and returning 'na'

       

      Calendar:

      LOAD TIME_PERIOD_YEAR,

          

           TIME_PERIOD_WEEK_NO,

           Date(TIME_PERIOD_START_DATE,'DD/MM/YYYY') as PERIOD_START_DATE,

           TIME_PERIOD_PERIOD,

           CALENDAR_MONTH_NUMBER,

           TIME_PERIOD_QUARTER_NO

      FROM

      [C:\Varsha\BI\QlikView\GSM Incident Metrics Performance - Detail July 2014 - by Assignment Group - Full Version\Calendar.xls]

      (biff, embedded labels, table is [Sheet1$]);

      STORE Calendar into Calendar.qvd(qvd);

       

       

      Mapping

      Cal_Map:

      LOAD

      PERIOD_START_DATE as date,

      TIME_PERIOD_PERIOD as Period

      Resident Calendar;

       

       

       

       

      Data:

      LOAD [Customer Sector],

           [Customer Region],

           [Customer Market],

           [Incident #],

           Field_Category,

           Priority,

           Impact,

           Urgency,

           [Division(s)],

           [Incident Type],

           Status,

           Environment,

           [MTTr - HHMMSS],

           [MTTr - H.hh],

           [MTTr - SLA],

           [MTTR - HHMMSS],

           [MTTR - H.hh],

           [MTTR - SLA],

           [MTTR -  SLA Text],

           [Assignment Group],

           Assignee,

           [Assignment Area],

           [Assignment Sub-Area],

           [Open Time],

           [Open Year],

           [Open Month],

           [Open Week],

           [OwnerGroup Group],

           Owner,

           [Respond Time],

           [Respond Year],

           [Respond Month],

           [Respond Week],

           [Resolved Time],

           Date(Timestamp#([Resolved Time],'YYYY/MM/DD hh:mm:ss'),'DD/MM/YYYY') as Resolved_Date,

           ApplyMap('Cal_Map',Date(Timestamp#([Resolved Time],'YYYY/MM/DD hh:mm:ss'),'DD/MM/YYYY'),'na') as Resolved_Period,

           [ReOpened Time],

           [ReOpened Year],

           [ReOpen Month],

           [ReOpened Week],

           [ReOpened By],

           [Resolved Year],

           [Resolved Month],

           [Resolved Week],

           [Resolved Group],

           [Resolved By],

           [Closed Time],

           [Closed Year],

           [Closed Month],

           [Closed Week],

           [Closed Group],

           [Closed By],

           [Customer Location],

           Title,

           Description,

           System,

           [Service Component],

           [Sub Service Component],

           [Affected CI],

           Vendor,

           [Closure Code],

           [Soution ID],

           [Knowlix Title],

           [Customer Last Name],

           [Customer First Name],

           [Customer Title],

           [Customer VIP],

           DeptID,

           Hops,

           [StarTeam CR Number],

           [StarTeam Flag],

           ProjectNumber,

           [Assist Group1],

           [Assist Assignee 1],

           [Assist Status 1],

           [Assist Group 2],

           [Assist Assignee 2],

           [Assist Status 2],

           Generic,

           [R7 Incident Flag],

           [Missed SLA Reason],

           [Ebonding Number],

           [Ebonding Category],

           [Ebond To],

           [Ebond Group],

           [Ebond Source],

           WorkAround_Impl,

           Sol.Appl.By,

           [Can Customer Solve ?],

           [Incident Flag],

           [Result of Change],

           [Incident Location],

           [Priority Increased],

           [Priority Decreased],

           [Outage Start],

           [Outage End],

           Workstation,

           Model,

           Resolution,

           [SAP Solution Type],

           [SAP Control Impacted],

           [SAP Control Type],

           [SAP Control Number],

           [SAP Table Impacted],

           [SAP Transport ID],

           Route,

           SLA_BREACH,

           [SLA Name],

           [SLA Expire]

      FROM

      [C:\Varsha\BI\QlikView\GSM Incident Metrics Performance - Detail July 2014 - by Assignment Group - Full Version\GSM Incident Metrics Performance - Detail July 2014 - by Assignment Group - Full Version.xls]

      (biff, embedded labels, table is [Data$]);

      store Data into Data.qvd(qvd);

       

      Please let me know where I am wrong.

      Thanks,

      Varsha