topic Reduce Data reduces unrelated Data in QlikView

Reduce Data reduces unrelated Data

amars — Wed, 05 Aug 2009 18:54:24 GMT

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

Reduce Data reduces unrelated Data

Gustav_Guldberg — Wed, 05 Aug 2009 19:09:46 GMT

Hi,

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

Regards,

Gustav

Reduce Data reduces unrelated Data

amars — Wed, 05 Aug 2009 19:58:39 GMT

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