Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

2 Replies
Not applicable
Author

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
Author

This really helped, thanks