Per Person Data

[Anonymous]

Good Afternoon;

   I have a need to split data on one dashboard between three people.

Example.  I have three supervisors who manage different individuals.  Upon logging into the dashboard i need them to see only the information related to those individuals they supervise.

How can this be accomplished?

Thank you in advance

Rich

[eduardo_dimperio]

You can use a this:

and create an expression based on user logged in

[MK9885]

Use Section Access based on the field you want to restrict and their NT Names

QlikView Section Access Examples

[Anonymous]

Could you explain a little more, I have not seen that in Qlikview.

[Anonymous]

Hello Khan;

    I have looked at the document, I think i understand, I have ACCESS, NTNAME, NTDOMAINSID.

Do i need to define the Admins as well?  Also the one thing i didnt see is how to set user 1 to group A of data, user 2 to group B, etc.  is that something different?

[MK9885]

Admin will be your ID where you give '*' in the field value... which would allow you to see all the fields/data in app.

How many users do you have in Group 1 and Group 2?

One way to do it is either create a 2 new AD groups in your AD group (request your help desk)

or manually enter the user names by assigning what fields they should see

You can use OMIt to restrict it by Colum and for Row just use the normal field name in Upper() for both fact field and your SA script.

If you can post a list of sample user & what you want them to be restricted then it would be easier to create a mock up script.

Remember: Always make a copy before applying section access so that you won't get locked out.

If it is used in Qlik Sense then right Qlik on app, open without data would work but Qlik View will not.. so make a copy of the app.

[eduardo_dimperio]

To be honest thos field exist on Qlik Sense, but i think that my be a similar in QV. It used to show a information only if that expression is satisfied

[Anonymous]

HI Khan;

  Here is what I have, i thought i got it, but the document fails to publish to the access point so I assume i have something wrong

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, DIVISION

    ADMIN, Domain\user1,

    USER, Domain\user2, ATC

    USER, Domain\user3, WBO

    USER, Domain\user4, VCE

];

Section Application;

I'm not sure what I am doing wrong i got it from example 6 and i made sure to go into the document settings.  Do i have something out of place?

[vishsaggi]

What is the error you are getting? Is the field Division in your table all UPPER case? I mean outside section access you have a table with Field Division whose values should also be in upper case.

[MK9885]

Star is *;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, DIVISION

    ADMIN, Domain\user1, *

    USER, Domain\user2, ATC

    USER, Domain\user3, WBO

    USER, Domain\user4, VCE

];

Section Application;

Make sure your Division field in fact or dimension table is in upper

Ex: rename the field

Upper(DIVISION) as DIVISION