Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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