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: 
diwaskarki
Creator II
Creator II

error in dimension

I am bringing in data from a resident table (SPT_IDENTITY) in the spt_identity4 table  and connecting it to spt_audit_event table. When I try to display the attribute from the spt_identity4 table in my list box, I see a red cross mark sign on the dimension in chart properties table. I have attached a picture of the chart properties table.

This is my script:

SPT_IDENTITY:
LOAD ID As IdentID,
NAME As IdentityAlias,
MANAGER As IdentManager,
FIRSTNAME As 'First Name',
LASTNAME As 'Last Name',
EXTENDED6 As IdentExtended6,
EXTENDED7 As IdentExtended7,
EXTENDED10 As IdentExtended10,
InactiveIndicator,
WORKGROUP As IdentWorkgroup
FROM [..\..\QVD\SPT_IDENTITY.qvd] (qvd);

SPT_IDENTITY4:
LOAD IdentityAlias As "AuditAutoFireRequestee",
[First Name] As "Requestee First Name",
[Last Name] As "Requestee Last Name"
RESIDENT SPT_IDENTITY; 


//Audit Event
SPT_AUDIT_EVENT:
LOAD ID As AuditID,
MODIFIED As AuditModified,
ACTION As AuditAction,
APPLICATION As AuditApp,
INSTANCE As AuditInstance,
Upper(TARGET & '.' & APPLICATION) As ManagedAttributeAuditKey3,
AuditLCMRequestID,
AuditAutoFireRequestee,
AuditAutoFireRequestID,
AuditAutoFireOffices,
AuditLCMCompletionDate,
date(date(floor(CREATED/1000/60/60/24))+date('1970-01-01')) as LCMCalendarDate,
TARGET As AuditTarget,
TemplateName,
EmailSentTo,
AuditEmailSentSubject,
SOURCE As "Audit Requested By",
TextBetween(ATTRIBUTES, '<entry key="Business Case" value="', '"/>') As "Audit Business Case",
TextBetween(TextBetween(ATTRIBUTES, '<entry key="Approved by RA" value="', '"/>'), '(', ')') As "Audit Approved by RA",
TextBetween(ATTRIBUTES, '<entry key="Completed by (PCU)" value="', '"/>') As "AuditAutoFire Approved by PCU",
TextBetween(ATTRIBUTES, '<entry key="Completed by (DSA)" value="', '"/>') As "AuditAutoFire Approved by DSA",
TextBetween(ATTRIBUTES, '<entry key="Completed by (Manager)" value="', '"/>') As "AuditAutoFire Approved by Manager",
TextBetween(TextBetween(ATTRIBUTES, '<entry key="Approved by Manager" value="', '"/>'), '(', ')') As "Audit Approved by Manager"
//TextBetween(TextBetween(ATTRIBUTES, '<entry key="Requested By" value="', '"/>'), '(', ')') As "Audit Requested By"
FROM [..\..\QVD\SPT_AUDIT_EVENT.qvd] (qvd);

errorcross.png


I would really appreciate the help. Thanks

1 Reply
Anonymous
Not applicable

it looks that the fields you re looking for are named "Requestee First Name" and "Requestee Last Name".

maybe the fields "Audit Requestee First Name" and "Audit Requestee Last Name" wer existing fields of a previous version of the app..