Applymap

Wed, 20 Aug 2014 13:11:22 GMT

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

Re: Applymap

qlikoqlik — Wed, 20 Aug 2014 13:21:00 GMT

Hi Varsha

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

regards

padma

Re: Re: Applymap

Wed, 20 Aug 2014 13:30:50 GMT

Hi Padma,

Please find the attached excels.

Thanks,

Varsha

Re: Applymap

ngulliver — Tue, 09 Sep 2014 08:51:46 GMT

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

Re: Applymap

Fri, 12 Sep 2014 11:11:52 GMT

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

topic Applymap in QlikView

Applymap

Re: Applymap

Re: Re: Applymap

Re: Applymap

Re: Applymap