Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER 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