incorrect data when correlating field

diwaskarki — Sat, 05 May 2018 20:07:53 GMT

Hello all,

My database has a table spt_identity that stores all the identity for our enterprise. I have already loaded this in qlikview under a table called spt_identity.

This sql query in my database: select count(alias) from spt_audit_event where instance='Automated Security Access Removal' "; returns 36 count of alias. (Alias is an identity by the way)

when I do this load in qlikview and display alias in a list box, data count is accurate.

I have correlated Table A which has the field alias to Table B so I can bring the Alias' first name and last name from Table B. When I do this, the list box displaying alias shows 94, instead of 36. Given Table and Table B are correlated shouldn't alias in my list box display data that are present in both Table and Table B? I dont think this is happening. What am I doing wrong?

topic incorrect data when correlating field in QlikView

incorrect data when correlating field