Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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,