topic Re: section access in QlikView

section access

Wed, 13 Mar 2013 05:07:26 GMT

Hello,

I have users from different branches.

As user opens the report he should be able to see data only of respective branche only.

So how to accomplish it?

Re: section access

Wed, 13 Mar 2013 05:16:23 GMT

try this

SECTION Access;

LOAD * INLINE [

Access, userid, password

user1, test1, pass1

user2, test2, pass2

user3, test3, pass3

];

SECTION Application;

Re: section access

Wed, 13 Mar 2013 05:29:42 GMT

Hi Vishwaranjan,

I tried this, but then it shows the login screen.

I want users to login once only in accesspoint and then use this user further in the reports wherever required.

Re: section access

sujeetsingh — Wed, 13 Mar 2013 05:50:56 GMT

Hi,

SECTION Access;

LOAD * INLINE [

Access, userid, password,Branch

user1, test1, pass1,B1

user2, test2, pass2,B2

user3, test3, pass3,B3

];

SECTION Application;

And then go to setting <<<Document Properties .<<<<opening<<<<<Check initial reduction ...

Re: section access

Wed, 13 Mar 2013 06:09:08 GMT

Hello,

I found the solution.

In the above code, I used OSUser.

Now it does not show the login screen, but shows the respective branch.

Thanks to both of you.

Re: section access

sujeetsingh — Wed, 13 Mar 2013 06:16:52 GMT

You are welcome!!!!

Re: section access

Wed, 13 Mar 2013 07:46:25 GMT

Hi Apurva,

Could you please attach you qvw file for reference?

Thanks,

Anju

Re: section access

khadeer — Wed, 13 Mar 2013 08:46:49 GMT

Hi following code solve ur issue .....

and check document properties.....Opening tab..... Initial data reduction based on section access.

SECTION Access;

LOAD * INLINE [

Access, userid, password

user1, test1, pass1

user2, test2, pass2

user3, test3, pass3

];

SECTION Application;

LOAD * INLINE [

userid, region

test1, 'Delhi'

test2, 'Mumbai'

test3, 'Pune'

];

Re: section access

Wed, 13 Mar 2013 09:32:14 GMT

Anju,

I cannot upload my file, as I have all the client data.

But the code given by others in this discussion works.

If you want to know anything else, please let me know.

Re: section access

Wed, 13 Mar 2013 09:36:30 GMT

Hi Apurva,

Is it possible to paste the code with function OSUser ?

Thanks,

Anju

Re: section access

Wed, 13 Mar 2013 09:40:17 GMT

Hi Anju,

Section Access;

LOAD * INLINE [

ACCESS, OSUser, BRANCH

ADMIN, test1, B1

ADMIN, test2, B2

];

Section Application;

And then go to setting <<<Document Properties .<<<<opening<<<<<Check initial data reduction based on section access and strict exclusion.

I am also testing it for different scenarios. Need to check if it works for all.

Re: section access

Wed, 13 Mar 2013 09:48:12 GMT

Hi,

I tried following code and it is not working.

Section Access;

LOAD * INLINE [

ACCESS, OSUser, BRANCH

USER, test1, B1

USER, test2, B2

];

Section Application;

If I use ADMIN in ACCESS, then it will work.

but when I use USER in ACCESS, then it is not working.

Re: section access

Wed, 13 Mar 2013 10:46:53 GMT

Thank you!

Re: section access

Wed, 13 Mar 2013 12:04:21 GMT

Hi Khadeer,

if I use ADMIN in ACCESS column, reload and I re-open report, it will show data as per the branch mentioned for the user in section access.

But when I use USER in ACCESS colu, reload and I re-open report, it shows all the data.

what I am doing wrong?

Re: section access

Thu, 14 Mar 2013 06:13:27 GMT

Please can any one help me on this?

Re: section access

khadeer — Sat, 16 Mar 2013 10:46:39 GMT

Hi Apurva,

I hope u r text is not matching with given text in section access. Please check that it works fine for me..

Suppose for user region 'Delhi' check as exactly in values in the table... it may b because of spaces n other.

Hope it helps u...

Re: section access

Mon, 18 Mar 2013 05:56:20 GMT

Hi Khadeer,

Section Access;

LOAD * INLINE [

ACCESS, OSUser, BRANCH

ADMIN, usr1, B1

ADMIN, usr1, B2

ADMIN, usr1, B3

ADMIN, usr1, B4

ADMIN, usr1, B5

ADMIN, usr1, B6

USER, usr2, B1

];

Section Application;

LOAD * INLINE [

USERID, BRANCH

usr1, B1

usr1, B2

usr1, B3

usr1, B4

usr1, B5

usr1, B6

usr2, B1

];

Above is my code.

But it is not working as expected.

for Usr1 it shows all the branches.

for usr2 it should show only branch1 but it is showing all the branches.

Re: section access

Mon, 18 Mar 2013 06:02:58 GMT

Hi ,

Section Access;

LOAD * INLINE [

ACCESS, OSUser, BRANCH

ADMIN, test1, B1

ADMIN, test2, B2

];

Section Application;

It is not working for both 'ADMIN' and 'USER'. The prompt itself is not appearing.

Re: section access

Mon, 18 Mar 2013 06:20:52 GMT

Hi anjugopinath,

if you want the login window to display then you need to use the

script given by Khadeer.

I didnot want to show the login screen, but directly use the OSUser,

so my script will not show the login prompt.

Re: section access

Mon, 18 Mar 2013 06:35:58 GMT

How does it verify the user then? I don't have any user named 'test1' or 'test2'. But, the document still opens.

And what is branch?