Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you help me please?? I have three different access level; admin, France,USA etc.
- Admin Should be able to view All
- When France logs in it should only only view Topic A which is Invoices table relevant to its country.
- When USA logs in it should only only view Topic B which is Sales table relevant to its country.
How do I restrict users based on a value (TOPIC A, TOPIC B etc) in the field Topic labelled as choose a topic.
I have used example codes from the URL below but It doesnt work for me;
http://community.qlik.com/message/242464
Your help will be appreciated.
Thanks in advance.
Humera
Hi QlikView Community, I have managed to find solution on my own. Try this code;
//Data reduction on certain field values
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, SAM, SAM
USER, NEIL, NEIL
];
Section Application;
LOAD * Inline [
USERID, Topic
SAM, Topic A
NEIL, Topic B
];
Cheers
Hi QlikView Community, I have managed to find solution on my own. Try this code;
//Data reduction on certain field values
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, SAM, SAM
USER, NEIL, NEIL
];
Section Application;
LOAD * Inline [
USERID, Topic
SAM, Topic A
NEIL, Topic B
];
Cheers
This really helped, thanks