Data Reduction on certain field values

[#1]

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

[#2 · Accepted solution]

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

[#3]

This really helped, thanks