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?
