Restrict User from accessing Values in listbox

renjithpl — Tue, 07 Jun 2011 16:00:56 GMT

Hi All,

I have a query related Section access/security.

I want my user to access to only certain listbox Values, only admin should have all access. I have attached an excel and qvw file. In the excel sheet, I have a listbox with called "AccountL01" with XXXXX , YYYYY, ZZZZZ values. And the AccountL01 Sheet in excel has the REDUCTION column gives the reduction id.

So in sheet1 of excel says

Sheet1:

USERID	PASSWORD	ACCESS	GROUP	ACCOUNTL01
Admin	123	ADMIN	*	*
B	123	USER	GROUP1	100
C	123	USER	GROUP2	101
D	123	USER	GROUP3	102
E	123	USER	GROUP4	101

AccountL01:

ACCOUNTL01	REDUCTION
XXXXX	100
YYYYYY	101
ZZZZZZ	102

My requirement is, when User B logs to open, the List box should only show XXXX rest should be disabled or hidden, Same way, when USER C and E log in, the List box should show YYYY and for D it should only see ZZZZZ. The Reduction id identifies the user.

Thanks.

Ranjit

topic Restrict User from accessing Values in listbox in QlikView

Restrict User from accessing Values in listbox