topic Re: Data Level Section Access in QlikView https://community.qlik.com/t5/QlikView/Data-Level-Section-Access/m-p/1545515#M751276 <P>In the Excel instert also the 3 columns (<SPAN>CIF_REGION,IA_REGION and Region</SPAN>) with the restricted values for every user.</P><P>Then you can use this expression to show the restricted values for every Dimension.</P><P><SPAN>=If(upper(OSUser())= USERID, Region)</SPAN></P><P><SPAN>=If(upper(OSUser())= USERID, CIF_REGION)</SPAN></P><P><SPAN>=If(upper(OSUser())= USERID, IA_REGION)</SPAN></P> Sun, 17 Feb 2019 12:02:15 GMT Claudiu_Anghelescu 2019-02-17T12:02:15Z Data Level Section Access https://community.qlik.com/t5/QlikView/Data-Level-Section-Access/m-p/140025#M751275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want data level restriction in object for particular sheet to particular user.</P><P>As in my application there is multiple sheets..out of which only for last sheet objects want to restrict data..?</P><P>how to achieve it..?</P><P>Thus for objects in sheet1 want to restrict data for CIF_REGION,IA_REGION and Region</P><P></P><P>Please do needfull..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Level-Section-Access/m-p/140025#M751275 dhavalvyas 2020-11-25T16:16:04Z Re: Data Level Section Access https://community.qlik.com/t5/QlikView/Data-Level-Section-Access/m-p/1545515#M751276 <P>In the Excel instert also the 3 columns (<SPAN>CIF_REGION,IA_REGION and Region</SPAN>) with the restricted values for every user.</P><P>Then you can use this expression to show the restricted values for every Dimension.</P><P><SPAN>=If(upper(OSUser())= USERID, Region)</SPAN></P><P><SPAN>=If(upper(OSUser())= USERID, CIF_REGION)</SPAN></P><P><SPAN>=If(upper(OSUser())= USERID, IA_REGION)</SPAN></P> Sun, 17 Feb 2019 12:02:15 GMT https://community.qlik.com/t5/QlikView/Data-Level-Section-Access/m-p/1545515#M751276 Claudiu_Anghelescu 2019-02-17T12:02:15Z