https://community.qlik.com/t5/QlikView/correlation-not-working-properly/m-p/1527337#M440932 <P>Hi, I have correlated two tables ( SPT_AUDIT_EVENT) &amp; (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.&nbsp;</P><P>&nbsp;</P><P>Key field 'xxYY' in spt_audit_event has information density of 7% and subset ratio of 89% whereas that field in spt_bundle3 has&nbsp; information density of 100%.&nbsp; This is my script from two different tables:</P><P>Subfield(Trim([New Removed Entitlements]),'),') As [xxYY],</P><P>Upper(Trim([RBAC Application])) &amp; ' | ' &amp; upper(Trim([RBAC Entitlements])) As [xxYY],</P><P>&nbsp;</P><P>What could be the issue?&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="corrleation.png" style="width: 823px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3209i17071D2066B1381D/image-size/large?v=v2&amp;px=999" role="button" title="corrleation.png" alt="corrleation.png" /></span></P> Sat, 16 Nov 2024 21:38:43 GMT diwaskarki 2024-11-16T21:38:43Z https://community.qlik.com/t5/QlikView/correlation-not-working-properly/m-p/1527337#M440932 <P>Hi, I have correlated two tables ( SPT_AUDIT_EVENT) &amp; (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.&nbsp;</P><P>&nbsp;</P><P>Key field 'xxYY' in spt_audit_event has information density of 7% and subset ratio of 89% whereas that field in spt_bundle3 has&nbsp; information density of 100%.&nbsp; This is my script from two different tables:</P><P>Subfield(Trim([New Removed Entitlements]),'),') As [xxYY],</P><P>Upper(Trim([RBAC Application])) &amp; ' | ' &amp; upper(Trim([RBAC Entitlements])) As [xxYY],</P><P>&nbsp;</P><P>What could be the issue?&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="corrleation.png" style="width: 823px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3209i17071D2066B1381D/image-size/large?v=v2&amp;px=999" role="button" title="corrleation.png" alt="corrleation.png" /></span></P> Sat, 16 Nov 2024 21:38:43 GMT https://community.qlik.com/t5/QlikView/correlation-not-working-properly/m-p/1527337#M440932 diwaskarki 2024-11-16T21:38:43Z