How to set so that mgt staff can view Tab=P&L ?

[paulyeo11]

Hi All

I have a QV doc , which having 8 Tab. one of the Tab = P&L , and for this Tab in side only mgt staff are allow to access . may i know can session access control allow to hide Tab = P&L ?

[Anonymous]

I don't think section access dirrectly ties into such user interface show conditonal options.

You can however set up a profile for the management users that reduces data, and then have a Show conditional test on a Sheet test if count of a field is 1 to show the sheet.

Queston then is what field to use. I think this could be a simple as a table that is not connected to the data model, though having not tried it am not sure whether this will exclude all the data. Try it out I guess.

You could maybe link your Section Access profiles to a table called Permissions, and then have your Show conditional test if count of 'Allow P&L' is 1 then show etc.

Jonathan

[paulyeo11]

Hi Jon

Thank you for your sharing. yes i like the idea of :-

Section Access profiles to a table called Permissions, and then have your Show conditional test if count of 'Allow P&L' is 1 then show

May be you can give me some idea , how the above can be implement on my session access code :-

Section Access;

LOAD * INLINE [

   SOURCE_SUP,SOURCE,SOURCE_GL,ACCESS, USERID, PASSWORD, NTNAME

    ,,,ADMIN, TDSS, 3066, *

    *,*,*,ADMIN, DEVELOPER, 123, *,*

    TDSS,TDSS,TDSS, USER, TDS, 1170, *

    *,*,*,USER, TDSM, 9170, *

    ADL,ADL,ADL, USER, ADL, 2171, *

    TDSPG,TDSPG,TDSPG, USER, TPG, 4172, *

    TDSKL,TDSKL,TDSKL, USER, TKL, 5173, *

    TDST,TDST,TDST, USER, TDT, 3174, *

    TIS,TID,TID, USER, TID, 6175, *

    *,*,*, ADMIN, *, *,TDS\demo,*   

    *,*,*, ADMIN, *, *,TDS\paul yeo,*   

    *,*,*, ADMIN, *, *,HENDRY\TDS Hendry,*   

    *,*,^, ADMIN, *, *,Paul\TDS Hendry,*  

    *,*,*, ADMIN, *, *,Paul\Paul Yeo,*  

    *,*,*, ADMIN, *, *,Test_8\tds,*

];

section application;

[marcus_sommer]

See here:

http://community.qlik.com/search.jspa?peopleEnabled=true&userID=&containerType=&container=&spotlight...

- Marcus

[paulyeo11]

Hi Macus

Thank you very much. your reply is good , i like it.

Paul