topic Re: section access in QlikView

section access

nizamsha — Mon, 20 May 2013 09:15:43 GMT

HI all

Can any one guide me through section access can u send me any good link

Re: section access

nizamsha — Mon, 20 May 2013 09:24:05 GMT

investor fund

5 4

5 6

10 8

10 9

15 12

20 15

25 20

this is my scenario in section access investor 5 has 2 funds

and also investor 10 has 2 funds if i login as a investor i should see my funds only for eg if i login as investor 5 i should see my funds only fund 4 and 5 like that for investor 10 i should see my frund 8 and 9 if i login as a admin i should see all the funds how i can do it please guide me i am trying but nothing happening

Re: section access

nizamsha — Mon, 20 May 2013 09:28:32 GMT

anyone guide mean i am trying but i am not getting

Re: section access

sushil353 — Mon, 20 May 2013 09:41:08 GMT

hi,

Please find attached...

Hope that will help you..

Sushil

Re: section access

sushil353 — Mon, 20 May 2013 09:53:00 GMT

Try this script:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

User, 5, 5

User, 10, 10

];

Section Application;

LOAD * Inline

[

USERID,fund

5,4

5,6

10,8

10,9

15,12

20,15

25,20

];

Also goto setting >document property>check intial data reduction based on section access.

HTH

Sushil

Re: section access

sushil353 — Mon, 20 May 2013 09:55:17 GMT

hi,

Please find the test app...

for admin: userid: admin , pwd: admin

for users: userid:5 , pwd: 5

and so on.

HTH

Sushil