Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data Reduction on certain field values

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

1 Solution

Accepted Solutions
Not applicable

Re: Data Reduction on certain field values

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

2 Replies
Not applicable

Re: Data Reduction on certain field values

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

Not applicable

Re: Data Reduction on certain field values

This really helped, thanks

Community Browser