topic Re: Section Access - QVD in QlikView

Section Access - QVD

Fri, 03 Feb 2012 12:47:21 GMT

I set up a simple section access for security in my app. I set it up for ADMIN and USER, NTNAME, and set 1 field to restrict the data to. When I set up the list of usernames and rights via an external spreadsheet it works great. But, we also have a process where we can create a Google Doc spreadsheet, and those get turned into QVD's (this way others in the business can manage their data). Now, when I try and set my app to pull my section access rights from the QVD, my app will not pull data from it, it fails out. Is this just the nature of QV oris there another way? Thanks,

Re: Section Access - QVD

jjfabian — Fri, 03 Feb 2012 12:53:23 GMT

There should not be a problem creating a QVD from a Google Doc Spreadsheet. Something else must be up.

Is your google spreadsheet formatted in the right manner for Section Access?

Section Access - QVD

Fri, 03 Feb 2012 12:59:50 GMT

hi,

Use resident from you qvd data, please see below

Sec:

LOAD ACCESS,

USERID,

PASSWORD,

SERIAL,

NTNAME

FROM

Sec.qvd

(qvd);

Section Access;

Load

ACCESS,

USERID,

PASSWORD,

SERIAL,

NTNAME

Resident Sec;

Section Application;

drop table Sec;

Section Access - QVD

Fri, 03 Feb 2012 13:31:14 GMT

Thank you. Also, my understanding is, under the document properties, security tab, I can unselect Allow Export and this will prevent USERS for exporting data. But when I hit apply, the XL icon on my charts disappears and I am the ADMIN. Any thoughts here? Also, in my section application section of my section access, I do not list out users who are ADMIN as when I log in, I can still see all of the data, so i assumed I only have to spell out the access for USERS. Could this have anything to do with allowing export? Thanks again,

Section Access - QVD

Fri, 03 Feb 2012 14:15:10 GMT

But when I hit apply, the XL icon on my charts disappears and I am the ADMIN. Any thoughts here? - you need to select also "Admin Override Security".

Also consider about the setting in yours management console. Go to tab "Documents" and choose you documents, in your right go to tab "Server" and choose to section "Availability". take a look at Print and Export to Excel option.

In section application mostly only will related to data reduction or selection at the first.

Section Access - QVD

Fri, 03 Feb 2012 14:59:52 GMT

Thank you again, I hate it when I miss something right in front of me. 🙂 With my section access set to limit the user to one value in the field, (field = Division, User can only see where Division = 50). Can set acces be expanded to also include an OMIT field after this? For example, we have Sales Org = 1100, Division 50 that all can see, but then I have Sales Org 2000, Division 50. I want the user to see all of Division 50 expect for Sales Org 2000, Divison 50. We have many Divisons under Sales Org 1100 , not just Division 50. Thanks.

Re: Section Access - QVD

Fri, 03 Feb 2012 15:19:02 GMT

hmm..u should find how to filter the value that came only from Sales Org 2000 in division 50 and use that in yours section application.

Might be like this

Sales Org, Division, SalesRepId

1100, 50, 1

1100, 40,

2000, 50, 2

need more analysis on the data itself

Re: Section Access - QVD

dangeneire — Tue, 08 Aug 2023 12:05:20 GMT

And if in QVD the field has name different of , for example instead of USERID USER_AD_ACCOUNT and instead of ACESS USER_ACESS_TYPE? I am asking because in the section access the "as" it appears that does not work .