Reg Security and Expansion

[#1]

Hi All,

I have 2 data files which contain manager’s data, One is ‘Demand Data’, other one is ‘Allocated’ data.

Here one manager contain sub managers, for ex: A is one manager and A contains B, C, D sub managers

  Like as follows

    

Again Manager B Contain sub managers as follows

Here my requirement is if manager A logs into the system then all the sub managers data should be shown and if Sub manager B logs into the system then E, F, G data should be shown along with his data.

If Sub manager E logs into the system, only his data should be shown.

I'm attaching sample Data files and QVW.

I will take one list box contains Manager’s names i.e. List box should be expandable. If I click on B the data should show as follows

If I click on  G then the data shown as below

Please somebody have a look into this and help me on this.

I'm attaching sample Data files and QVW.

Thanks,

Chiru

[salto]

Hello,

you should use Section Access and Section Application for this, and enable Data Reduction based on Section Access int he document Properties "On Open"  tab.

Create a hidden script in the document, more or less like this:

Section Access;

[SECURITY]:

LOAD

    USERID,     

    ACCESS,

    REDUCTION

FROM Reductions.xls (biff, embedded labels, table is Security$);

Section Application;

STAR IS *;

Access:

LOAD

  REDUCTION,

  MANAGER

FROM Reductions.xls (biff, embedded labels, table is Reduction$);

PFA the Reductions.xls Excel sheet.

[salto]

I would also recommend you to have a look at http://community.qlik.com/docs/DOC-1853 and check the basics in data reduction.

Hope this helps!

[Gysbert_Wassenaar]

See attached qvw. And if you want to make sure that a manager can only see the records of himself and his subordinates you need to use section access like mentioned above.

[#5]

Hi SALTO,

Thanks for your reply,

I tried with your suggestion,But still i'm getting error result.

If i login as Manager 'A' all the data showed, If i login as Manager 'E' also all the data showed.

Please send me one sample QVW, it will be helpful to me.

Thanks,

Chiru

[#6]

Hi Wassenaar,

Now i added Allocated File here,

Please have a look and give me some suggestion.

Thanks,

Chiru

[salto]

There it goes. I had an error in the previous message, I have corrected it now.

Please check. It mkes the reductions, anyway you need to correct the Demand and Allocation and shjow only one Manager in each row.

Regards,

[salto]

I forgot.... the password for the hidden script is 1

Regards.

[#9]

Hi Salto,

Thanks for your support and reply

But still i didn't reach my requirement, Actually my req is if login as 'A' then all the data from A,B,C,D,E,F,G,H,I,J,K should show.

And if login as 'B' then all the data from B,E,F,G should show,

if i login as 'C' then all the data from C,H,I should show,

if i login as 'D' then all the data from D,J,K should show

This is my exact requirement, Please help me on this.

Thanks,

Chiru

[salto]

Hi,

for me, this is exactly how it works... If I open with 'A', I see all managers, with 'B', only B,E,F,G.. and so on. Are you opening my document with reuctions.xls file in the same folder?

Regards,