topic section access in QlikView https://community.qlik.com/t5/QlikView/section-access/m-p/171647#M41567 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>not sure what kind of problem you realy have. But see the attached example for help.</P><P>User: ADMIN, DEMO1, DEMO2, DEMO3</P><P>Password: P</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Mon, 08 Mar 2010 16:53:13 GMT 2010-03-08T16:53:13Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171645#M41565 <HTML><HEAD></HEAD><BODY><P>I'm trying to reduce the data in my Qlikview document based on who logs in. To accomplish this, I have added a 'section access' to my script, with a LOAD statement in it to load two users: 'admin' and 'user'. I have added an extra column ('cluster') to this inline table, with the extra column having the exact same name as a fieldname that is used in the 'section application'. I have also checked the 'Initial data reduction...' checkbox on the document properties tab.</P><P>The idea is that user 'user' gets a reduced set of data (using the 'cluster' column) and that user 'admin' gets to see it all. However, it's not working as expected: 'user' can still select/see different 'cluster' values in the document and is not restricted to the one I specified in the 'section access'. Am I missing something here?</P></BODY></HTML> Mon, 08 Mar 2010 16:30:00 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171645#M41565 2010-03-08T16:30:00Z Re: section access https://community.qlik.com/t5/QlikView/section-access/m-p/171646#M41566 <HTML><HEAD></HEAD><BODY><P>All field names in section access must be in all-caps. Don't worry about converting your field in the DB, since that will be done automatically for section access purposes. See the Reference Manual, pages 510 - 511 for more details.</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Mon, 08 Mar 2010 16:47:15 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171646#M41566 vgutkovsky 2010-03-08T16:47:15Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171647#M41567 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>not sure what kind of problem you realy have. But see the attached example for help.</P><P>User: ADMIN, DEMO1, DEMO2, DEMO3</P><P>Password: P</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Mon, 08 Mar 2010 16:53:13 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171647#M41567 2010-03-08T16:53:13Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171648#M41568 <HTML><HEAD></HEAD><BODY><P>I have read those pages, but from what I read, I figured I could make up my own column name (not restricted to 'REDUCTION'), as long as it matches one in my data.</P><P>Anyway, I simplified the fieldname and made it all caps, and now it is working. Thanks for your suggestions and the excellent example!</P></BODY></HTML> Mon, 08 Mar 2010 17:09:00 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171648#M41568 2010-03-08T17:09:00Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171649#M41569 <HTML><HEAD></HEAD><BODY><P>Thx a zillion for example.</P></BODY></HTML> Mon, 08 Mar 2010 18:51:55 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171649#M41569 2010-03-08T18:51:55Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171650#M41570 <HTML><HEAD></HEAD><BODY><P>Just a quick thank you to Rainer - I have used your example to help me to get this working after hours of messing around. Many thanks.</P></BODY></HTML> Mon, 02 Aug 2010 12:51:40 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171650#M41570 2010-08-02T12:51:40Z section access https://community.qlik.com/t5/QlikView/section-access/m-p/171651#M41571 <HTML><HEAD></HEAD><BODY><P>Muchas gracias por el ejemplo, muy ilustrativo. </P></BODY></HTML> Tue, 27 Sep 2011 23:47:17 GMT https://community.qlik.com/t5/QlikView/section-access/m-p/171651#M41571 2011-09-27T23:47:17Z