topic Section Access : OMIT field in QlikView https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517497#M193209 <HTML><HEAD></HEAD><BODY><P>Hi evrybody,</P><P></P><P>I tried in a section access to OMIT a special field (Emp.salary which&nbsp; is loaded before). But when i'm doing it I don't have the access control anymore.</P><P>Any clue will be appreciated.</P><P></P><P>Acces:</P><P>LOAD distinct</P><P>&nbsp;&nbsp;&nbsp;&nbsp; NIVEAU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as ACCESS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; LOGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as USERID, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; PWD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as PASSWORD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Emp.Salary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as OMIT,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // WHY THIS MAKE DISAPPEAR THE ACCESS CONTROL&nbsp; : LOGIN/PASSWORD ??</P><P>&nbsp;&nbsp;&nbsp;&nbsp; LVL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as OBJ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; MAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as DEPT</P><P>FROM Data\secu.xls</P><P>(biff, embedded labels, table is [Sheet1$])</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Thu, 27 Jun 2013 15:46:19 GMT 2013-06-27T15:46:19Z Section Access : OMIT field https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517497#M193209 <HTML><HEAD></HEAD><BODY><P>Hi evrybody,</P><P></P><P>I tried in a section access to OMIT a special field (Emp.salary which&nbsp; is loaded before). But when i'm doing it I don't have the access control anymore.</P><P>Any clue will be appreciated.</P><P></P><P>Acces:</P><P>LOAD distinct</P><P>&nbsp;&nbsp;&nbsp;&nbsp; NIVEAU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as ACCESS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; LOGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as USERID, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; PWD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as PASSWORD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Emp.Salary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as OMIT,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // WHY THIS MAKE DISAPPEAR THE ACCESS CONTROL&nbsp; : LOGIN/PASSWORD ??</P><P>&nbsp;&nbsp;&nbsp;&nbsp; LVL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as OBJ, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; MAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as DEPT</P><P>FROM Data\secu.xls</P><P>(biff, embedded labels, table is [Sheet1$])</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Thu, 27 Jun 2013 15:46:19 GMT https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517497#M193209 2013-06-27T15:46:19Z Re: Section Access : OMIT field https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517498#M193210 <HTML><HEAD></HEAD><BODY><P> Emp.Salary as OMIT, &lt;- This will use the field values in the field Emp.Salary as fields to omit. What you probably want is to use the literal value: 'Emp.Salary' as OMIT.<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Thu, 27 Jun 2013 16:33:00 GMT https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517498#M193210 Gysbert_Wassenaar 2013-06-27T16:33:00Z Re: Section Access : OMIT field https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517499#M193211 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>you're successfully right</P><P>thank you</P><P>chris</P></BODY></HTML> Fri, 28 Jun 2013 09:41:35 GMT https://community.qlik.com/t5/QlikView/Section-Access-OMIT-field/m-p/517499#M193211 2013-06-28T09:41:35Z