Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

(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

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

store Data into Data.qvd(qvd);

Please let me know where I am wrong.

Thanks,

Varsha

4 Replies
qlikoqlik
Creator
Creator

Hi Varsha

it would be definitely due to date fields, is it possible to have sample data

regards

padma

Not applicable
Author

Hi Padma,

Please find the attached excels.

Thanks,

Varsha

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Varsha.

If this is still an outstanding issue for you, have a look at this blog for help.

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

If you have resolved this, please mark this post as resolved so that other people can use your solution.

Thanks,

Neil

Not applicable
Author

Hi Neil,

I had checked this above blog before. I felt it was because of the date field so I split the date field and then concatenated and then used apply map, its working as required.

Regards,

Varsha