The feature you're looking for is "Section Access/Reduction" based on NTNAME
There is a very comprehensive guide here:
Just make sure you make a backup copy of your app without section access as everyone locks themself out at least once
A simple section access for what you are looking for would be as follows:
1.- First back your document up just in case something goes wrong
2.- Then create the following script at the beginning or at the end
STAR IS *; SECTION ACCESS; SectionAccess: // For example purposes being read from inline, any other valid source will workLOAD * INLINE [ACCESS, NTNAME, REDUCTIONADMIN, DOMAIN\ADMINISTRATOR, *USER, DOMAIN\A, AUSER, DOMAIN\B, B]; SECTION APPLICATION;ReductionTable:LOAD * INLINE [REDUCTION, REGIONA, BrazilB, France]; Data:LOAD Region, RevenueFROM Source
3.- Go to Settings, Document Properties, Open and check "Select data based on Section Access"
4.- Reload, close QlikView and open QlikView.
5.- If everything went fine, that is, your domain user credentials were passed on to the document, then you will see one of both regions selected. If that's the case, go back to Settings, Document Properties, Open and check instead "Reduce data..." and "Strict Exclusion".
6.- Close QlikView, open the document again and you should see only the records related to the user you are logged on (in my example DOMAIN\A or DOMAIN\B
Hope this helps.