Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
puneet122016
Contributor
Contributor

Data Duplication

I have tried the following link de-identify data for certain users

https://community.qlik.com/docs/DOC-18235

Mask or de-identify data for certain users using Section Access

But when I add the extra school for the user then the data gets duplicated for that user.

eg I have added the following lines

1.  userA,SchoolD

2. SchoolD,Philp_1,Andrew_1,Maths_1,77

for eg:

Load * Inline

[

    USERID,School

    userA,SchoolA

    userB,SchoolB

    userA,SchoolD

    userC,<ANY>

];

Result:

LOAD * Inline

[

    School,Teacher,Student,Subject,Result

    SchoolA,Anne,Peter,History,80

    SchoolB,Simon,Jhon,Maths,70

    SchoolC,Tony,Paul,History,58

    SchoolA,Stuart,Mathew,Maths,90

    SchoolB,Chris,Kai,Science,82

    SchoolC,Philp,Andrew,Maths,66

    SchoolD,Philp_1,Andrew_1,Maths_1,77

];

0 Replies