Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diwaskarki
Creator II
Creator II

correlation not working properly

Hi, I have correlated two tables ( SPT_AUDIT_EVENT) & (SPT_BUNDLE3) but the correlation is not working. Not working as in when I select a row in RBACType from spt_bundle3, correlating field in spt_audit_event is not populated. 

 

Key field 'xxYY' in spt_audit_event has information density of 7% and subset ratio of 89% whereas that field in spt_bundle3 has  information density of 100%.  This is my script from two different tables:

Subfield(Trim([New Removed Entitlements]),'),') As [xxYY],

Upper(Trim([RBAC Application])) & ' | ' & upper(Trim([RBAC Entitlements])) As [xxYY],

 

What could be the issue? 

 

corrleation.png

Labels (2)
0 Replies