Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

Reduce Data reduces unrelated Data

HI all,

I am using section access & reduce data, to show a user data related to him only. But it reduces unrelated data also. (i.e. when I make the same selection & reload the data and one with section access) are different. I don't understand why this is happening

Regards

Amar

Labels (1)
2 Replies
Gustav_Guldberg
Employee
Employee

Hi,

Could you please post your script and a few example of where it fails?

Regards,


Gustav

amars
Specialist
Specialist
Author

HI

My section access is having three types of user SuperAdmin, Admin & individual user

Section Access;

SecTab:

Load 'USER' as ACCESS, EmpID as USERID, '*' as PASSWORD, SAP_EmpID as GROUP1, 'all' as OMITGROUP Resident ccCORSAP_UserXref;

LOAD 'ADMIN' as ACCESS, 'SUPERADMIN' as USERID, 'SUPERADMIN123' as PASSWORD, 'xyz' as GROUP1, 'all' as OMITGROUP autogenerate 1;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GROUP1, OMITGROUP

USER, NAADMIN, NAADMIN123, NA, all

USER, EUADMIN, EUADMIN123, EU, all];



Now when I login with the SuperADMIN it already have reduced data but there is no relation between GROUP1 & any other field, When the file is opened it show's reduced figure but when I reload it , It show's some different figures. I have tried removing strict exclusion & again applying it but it is of no use.

Thank's & Regards

Amar