Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Applymap

Hi Varsha

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

regards

padma

Not applicable

Re: Re: Applymap

Hi Padma,

Please find the attached excels.

Thanks,

Varsha

ngulliver
Not applicable

Re: Applymap

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

Re: Applymap

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