topic Section access in QlikView

Section access

Fri, 31 Dec 2010 20:02:20 GMT

Hi all,

Under document properties I enabled "Initial Data reduction based on Section Access."

Now as expected when a user opens the document he will get prompted with username and password.

I tried different version with all upperletter etc but can't get in...someone know why?

Any hint much appreciated...

Thx L

Section access

Sat, 01 Jan 2011 01:19:36 GMT

Hi all,

Ok, I got this halfway going.....

I found some sample load script in the help and created this...

section access;

load * inline

[UserID,DEPT,Access

John,FINANCE,Admin

ANN,IS,Admin

Peter,SALES,User

Ben,TECH,User ];

section application;

star is *;

load * inline

[DEPT,CostCenter

FINANCE,*

IS,5020

SALES,5030

TECH,5040 ] ;

So when I log in as Peter I only see the costcenter 5030 which is correct based on the tables above...

Now, ideally I can login with windows credentials and I was hoping when I add my windows account to the inline table in the access section above it would work, but I still have to type my account into the user id box coming up when I open the document. Why is this? How can I make it to "see" my windwos account and pass it through?

I also have some buttons on a sheet which I'd like to be visible or not depending on the user. I tried adding a second table for the users button relationship within the access section but it didn't accept it. How would that work?

Any hint much appreciated.

Best Regards

Ludwig

Section access

prieper — Sat, 01 Jan 2011 11:15:48 GMT

User NTNAME instead of USERID as header of the field

HTH
Peter

Section access

amien — Sat, 01 Jan 2011 12:40:39 GMT

with section access and section application .. what will the result be if a selection is made?

uses will only see the costcenter 5030 .. but will there be an additional data reduction somehow if a selection is made?

with selection i mean if i open a qvw from the server, make a selection, close the application .. and then open the qvw again .. the selection is still there. will that effect the data reduce option?

Section access

Mon, 03 Jan 2011 20:43:01 GMT

Thx Peter, that did it. Ludwig

Section access

Mon, 03 Jan 2011 20:53:17 GMT

Hi Amien,

My answers below in <>

with section access and section application .. what will the result be if a selection is made?

uses will only see the costcenter 5030 .. but will there be an additional data reduction somehow if a selection is made?

with selection i mean if i open a qvw from the server, make a selection, close the application .. and then open the qvw again .. the selection is still there. will that effect the data reduce option?

Thx

Ludwig

Section access

Thu, 13 Jan 2011 13:47:31 GMT

Hi Ludwig,

I'm working around the same issue as you have, and I'd like to ask if you have a qvw where the Section Access is used.

I've been trying to create a script using it, but didn't have success.

Tks a lot!

Sheila