How to put security mechanism in Qlikview

[#1]

Hi,

Some one please tell me that how can I put sheet level security in qlikview application.

I am writing the following code:-

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, GROUP
Admin, Admin, Admin, G0
User, gaurav1, gaurav1, G1
User, gaurav2, gaurav2, G2
];


Section Application;

STAR IS *;

PLReduce:
LOAD * INLINE [
GROUP, SH01, SH03, SH04, SH05
G0, 1,1,1,1
G1, 1,0,0,0
G2, 0,0,0,1
];

But when I login with gaurav 2, all the sheets are visible whereas only SH05 should be visible.

Please help me.

Thanks and Regards,

Gaurav

[Anonymous]

You have to set up a conditional display expression based on the value of SHxx field. EG: for sheet 1-> sum(distinct if(SH01 = 1,1,0))