Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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!
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.
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
Hi Wassenaar,
Now i added Allocated File here,
Please have a look and give me some suggestion.
Thanks,
Chiru
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,
I forgot.... the password for the hidden script is 1
Regards.
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
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,