topic Re: Reg Security and Expansion in QlikView

Reg Security and Expansion

Mon, 04 Nov 2013 11:00:38 GMT

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

Re: Reg Security and Expansion

salto — Mon, 04 Nov 2013 11:44:44 GMT

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.

Re: Reg Security and Expansion

salto — Mon, 04 Nov 2013 11:57:03 GMT

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!

Re: Reg Security and Expansion

Gysbert_Wassenaar — Mon, 04 Nov 2013 13:01:53 GMT

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.

Re: Reg Security and Expansion

Mon, 04 Nov 2013 14:03:39 GMT

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

Re: Reg Security and Expansion

Mon, 04 Nov 2013 14:13:45 GMT

Hi Wassenaar,

Now i added Allocated File here,

Please have a look and give me some suggestion.

Thanks,

Chiru

Re: Re: Reg Security and Expansion

salto — Mon, 04 Nov 2013 14:21:43 GMT

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,

Re: Reg Security and Expansion

salto — Mon, 04 Nov 2013 15:31:56 GMT

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

Regards.

Re: Reg Security and Expansion

Mon, 04 Nov 2013 15:42:10 GMT

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

Re: Reg Security and Expansion

salto — Mon, 04 Nov 2013 15:53:52 GMT

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,

Re: Reg Security and Expansion

Mon, 04 Nov 2013 16:29:09 GMT

Hi Salto,

If i login as 'A' then the demand is 52.9, Allocated is 52.25 and Gap is 0.65,

if i login as 'B' then the demand is 17.1, Allocated is 16.6 and Gap is 0.5 ......

By default Only Manager 'A' should be shown, if we expand 'A' then B,C,D should show.

This is my exact requirement.

i'm sorry for troubling you, i hope you'll help me on this.

Thanks,

Chiru

Re: Reg Security and Expansion

Mon, 04 Nov 2013 18:16:15 GMT

Hi Wassenaar,

My Requirement is

If i login as 'A' then the demand is 52.9(it is the total of A+B+C+D+E+F+G+H+I+J+K) Allocated is 52.25 and Gap is 0.65,

if i login as 'B' then the demand is 17.1(B+E+F+G), Allocated is 16.6(B+E+F+G) and Gap is 0.5 ......

By default Only Manager 'A' only should be shown, if we expand 'A' then B,C,D should show and value is as follows

If i login as 'B' then the data which is related to B should show as follows

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

Thanks,

Chiru.

Re: Reg Security and Expansion

Gysbert_Wassenaar — Mon, 04 Nov 2013 19:17:37 GMT

See attached file.

Re: Reg Security and Expansion

Tue, 05 Nov 2013 09:23:24 GMT

Hi Wassenaar,

Thank you very much for your Reply, this is what exactly i expected.

Once again thanks for your support.

Thanks,

Chiru

Re: Re: Reg Security and Expansion

Thu, 14 Nov 2013 09:40:54 GMT

Hi Wassenaar,

Please give me solution for this and now i'm attaching my datamodel QVW and data files.

Please take a look and give me solution, we are working on this from last 4 days but we didn't get solution.

Please provide me some suggestion.

Thanks,

Chiru