topic Limit user from seeing his Colleagues' data in QlikView

Limit user from seeing his Colleagues' data

Fri, 01 Jun 2012 10:43:22 GMT

Hi,

I have a table named Account Manager (lets call it AM). I need that the administrators can see all of AM names in this dimension, but on the other hand, an account manger is allowed to see only his name, and all the others account managers will get the name "Other AM' (so we conceal the names of the other account managers, but not the data itself).

How can i accomplish this?

Thanks,

Guy

Limit user from seeing his Colleagues' data

Fri, 01 Jun 2012 10:52:42 GMT

First I'd check how osuser() displays, then I'd map user names to the Account Handler names in your script.

Username, AccountHandler

sys\c.j,Chris

Then, on your chart I'd set up your dimension to say if(osuser()=Username,AccountHandler,'Other AM')

This will however group all your account handlers into one row...

Re: Limit user from seeing his Colleagues' data

Fri, 01 Jun 2012 12:47:05 GMT

What i am trying to achieve is a way that when a user log into the QlikView Document, the Account Manger dimension will be actually changed this way:

From:

Account Manager ID	Account Manager Name
1	Guy Dav
2	Yuri Gal
3	Galfend Ami
4	Annand Tiber

To:

Account Manager ID	Account Manager Name
1	Guy Dav
2	Other AM
3	Other AM
4	Other AM

It is importent since i need to use the dimension in a SET ANLYSIS expression, and i beleive that a solution as described above will be suitable for this porpose.

Thanks,