Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

denwo2010
Contributor

UnQualify and Concantenate issue

Hi,

I have issue with the below script for some reason it is not showing data from the qvd's

S1-OpenCalls.qvd and S1-ProcessExceptions.qvd ?

It shows data from the S1-ClosedCalls.qvd (EUC) but nothe the other qvd's, any idea's why this is?

unqualify *;

Qualify *;
unqualify DB;
unqualify EUCalendarkey;
unqualify EUCALLNO;
unqualify EUCallAgeCode;
unqualify EUCALLPK;
unqualify EUExtractDate;
unqualify EULoggedTodayFlag;

EUCal:
LOAD
     Db as DB  ,
     CalendarKey as EUCalendarkey,
     [Engineer ID],
     [Eng Day],
     [Eng Quarter],
     [Eng Date],
     [Eng Week],
     [Eng Month],
     [Eng Year],
     [Eng Day of Week],
     [Std Hours],
     [Avail Day Flag],
     HOLS,
     UNAV,
     DOCT,
     SICK,
     SITE,
     TRAIN,
     [Total Unavail Hours],
     [Min Arrive Time],
     [Max Leave Time],
     [Worked Day Flag],
     [Extra Day Flag],
     [Extra Day Hours],
     [Unavailable Days],
     [Paid Time],
     [Worked Hours],
     [First Name],
     [Last Name],
     [Person Type],
     [Person Group],
     [Person Class],
     [Engineer OSG B],
     [Engineer OSG C],
     [Engineer OSG D],
     [Person Category],
     [Eng Start Month]
FROM
[$(vDataPath)\S1-EngineerCalendar.qvd]
(qvd); 

//EuVisit table
EUV:
LOAD
     VisitKey, 
     CalendarKey AS EUCalendarkey,
     [Visit No],
     [Call No] AS EUCALLNO,
     VisitCount, 
     [Month Year Visit],
     [Arrival Date and Time],
     [Arrival Date],
     [Leave Date and Time],
     [Leave Date],
     [Arrive Time],
     [Leave Time],
     [Arrive Day],
     [Time on Site],
     [Travel Time],
     [Field Time],
     [Visit OnSite Time],
     Mileage,
     [PGL Travel],
     [Parts Used],
     [Visit Fix Flag],
     [Visit FTF Flag],
     [Std Model Time],
     [Travel Allowance]

FROM
[$(vDataPath)\S1-Visits.qvd]
(qvd);


//Load EUCalls
EUC:
LOAD [Customer Group 2],       //COMPLETED CALLS
     [Customer Group 1],
     [Call Type],
     [Call Category],
     [Call No] aS EUCALLNO,
     [Call No PN PK],
     [Exception Code],
     [Exception Area],
     [Fix Exception Flag],
     [Rejected Flag],
     [Mitigation Code],
     [Mitigation Area],
     Mitigated,
     [Time Changed Flag],
     [Uncoded Flag],
     [Coded Flag],
     [MIT True Flag],
     [Customer Ref],
     [NRPM Flag],
     [BAPM Flag],
     [LDPM Flag],
     [Hold Flag],
     [MIT Hold Flag],
     [Fix Exc Hold Flag],
     [Hold TCNM Flag],
     [MIT Non Hold Flag],
     [String Id],
     Queue,
     [Request Type],
     Severity,
     [Severity (C)],
     Resolution,
     [Fix Engineer Name],
     [First Time Fix Flag],
     [User Def 1],
     [Default Brand],
     Priority,
     [Problem Code],
     [Logged By ID],
     [First TST Update ID],
     [First TST Update Date Time],
     [First TST B4 Fail Flag],
     [First TST Time],
     [First TST 30 Mins from Log Flag],
     [First TST Flag],
     [Logged Date],
     [Logged Date Time],
     [Logged Hour],
     [Contract Type],
     [Payment ID],
     [Model ID],
     Model,
     [Product Family],
     [Chargeable Call Flag],
     [Serial No],
     [Actual Fix],
     [Completed Date Time],
     [Completed Date],
     [Open Date Time],
     [Target Fix],
     [Total Visits],
     [DS Flag],
     [DS Category],
     [Total Parts Usage],
     [Total Parts Used],
     [Total Parts Used Flag],
     [Total Parts Needs],
     [Total Parts Needed],
     [SLA Fail Date Time],
     [BAE Call Type],
     [Reopened Flag],
     [Site ID],
     Branch,
     Account,
     [Post Code],
     City,
     Customer,
     [PSG A],
     [PSG B],
     [PSG C],
     [PSG D],
     [PSG E],
     [OSG A],
     [OSG B],
     [OSG C],
     [OSG D],
     [OSG E],
     [Customer Group 3],
     [Target SLA],
     [Customer Tier],
     [Clearance Level],
     [Clearance Flag],
     [Test Flag (TST Fix)],
     [Exception Description],
     [Mitigation Description],
     [Exec Name],
     [Manager Name],
     [Onsite Time (Tm2)],
     [PDA Completed],     
     [3RD],
     TSTQ,
     [Created ID Warranty],
     [Period No],
     [Period No Format],
     [Warr Checked],
     [Place ID],
     [SLA Flag],
     [SLA Flag Detail]     

FROM
[$(vDataPath)\S1-ClosedCalls.qvd]
(qvd);

CONCATENATE
LOAD [Call Type],      //OPEN Calls
     [Call Category],
     [Call PK] as EUCALLPK,
     [Call No] AS EUCALLNO,
     [Call No PN PK],
     [Customer Ref],
     Customer,
     [String Id],
     Queue,
     [Action Status],
     Severity,
     [Severity (C)],
     Status,
     [Logged By ID],
     [Logged Date],
     [2 Day Flag],
     [5 Day Flag],
     [7 Day Flag],
     [14 Day Flag],
     [Logged Date Time],
     [Logged Time],
     [Logged Hour],
     [Logged OOH Flag],
     [Logged OOH],
     [Obliged Arrive (Appt)],
     [Contract Type],
     [Payment ID],
     [Model ID],
     Model,
     [Product Name],
     [Product Family],
     [Serial No],
     City,
     [Post Code],
     [PSG A],
     [PSG B],
     [PSG C],
     [PSG D],
     [Last Text Code],
     [Last Text Date],
     [Last Text],
     [Last Text By],
     [Assigned To],
     [Assigned Person],
     [FE ETA],
     [FE Assignment Date Time],
     [FE Time On Site],
     [FE Planned Today Flag],
     [FE ETA Expired Flag],
     [FE ETA OK Flag],
     [FE Not Planned],
     [Target Fix],
     [Total Visits],
     [DS Flag],
     [DS Category], 
     [Total Parts Needs],
     [Total Parts Needed],
     [SLA Fail Date Time],
     [SLA Fail Date Time Minus Hour],
     [SLA Left],
     [SLA RAG],
     [SLA RAG Sort],
     [SLA Flag (In SLA)],
     [SLA Expired Flag (Out SLA)],
     [SLA Hold Flag (Hold SLA)],
     [String Count],
     [BAE Call Type],
     [PDA Current Status],
     [PDA Last Update],
     [PDA Current Status Order],
     [Place ID],
     Branch,
     Account,
     [Customer Group 1],
     [Customer Group 3],
     [Target SLA],
     [Customer Tier],
     [Clearance Level],
     [Clearance Flag],
     [Extract Date Time] as EUExtractDate
FROM
[$(vDataPath)\S1-OpenCalls.qvd]
(qvd);


CONCATENATE
LOAD [Call PK] as EUCALLPK,     //Process Exceptions
     [Call Type],
     [Call Category],
     [Call No] aS EUCALLNO,
     [Call No PN PK],
     Customer,
     [Logged Date],
     [Logged Date Time],
     [Completed Date Time],
     [Completed Date],
     [Rejected Flag],
     [Completed Flag],
     [Fixed Flag],
     [Fixed After Completed Flag],
     [Contract Type],
     [Site ID],
     [DS Flag],
     [DS Category],
     [Missing Model ID],
     [Action Status],
     [Model ID],
     Queue,
     [BAE Call Type],
     [Cross Reference],
     [User Def 1],
     [Customer Group 1],
     [Customer Group 2],
     [Customer Group 3],
     [Target SLA],
     [Customer Tier],
     [Clearance Level],
     [Clearance Flag]
FROM
[$(vDataPath)\S1-ProcessExceptions.qvd]
(qvd);

Tags (2)
25 Replies
Not applicable

UnQualify and Concantenate issue

Hi,

  Can u please upload your application.

Regards,

Antony.

denwo2010
Contributor

UnQualify and Concantenate issue

Hi the script is here or is there another way to add the script?

denwo2010
Contributor

UnQualify and Concantenate issue

Hi,  Can you see the script now?

Not applicable

UnQualify and Concantenate issue

Hi,

     please send your data it would be very easy to find the problems.

Regards,

Antony.

Not applicable

UnQualify and Concantenate issue

i have one query , which are the tables not showing ??? can you listed those tables???

denwo2010
Contributor

UnQualify and Concantenate issue

Its one query that is creating 3 tables:

EUCal,

EUV,

EUCalls

I am having a issue with the EUCalls, for some reason it is not showing data from the CONCATENATE qvd files from S1-OpenCalls.qvd and S1-ProcessExceptions.qvd

Not applicable

UnQualify and Concantenate issue

S1-OpenCalls.qvd and S1-ProcessExceptions.qvd both the tables merged in EUCalls table....

denwo2010
Contributor

UnQualify and Concantenate issue

Yes they are both merged in the EUCalls table, so not sure if the Concatemate is causing a issue?

Not applicable

UnQualify and Concantenate issue

Have u checked in application whether its showing the data or not after reload......

Community Browser