topic Re: Data Reduction on certain field values in QlikView

Data Reduction on certain field values

Thu, 23 Aug 2012 14:33:12 GMT

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

Re: Data Reduction on certain field values

Sat, 25 Aug 2012 17:27:05 GMT

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

Re: Data Reduction on certain field values

Mon, 01 Oct 2012 08:54:03 GMT

This really helped, thanks