Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access - QVD

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,

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

7 Replies
jjfabian
Partner - Creator III
Partner - Creator III

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?

Not applicable
Author

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;

Not applicable
Author

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,

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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

dangeneire
Contributor II
Contributor II

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 . 

BI Analyst
Qlik, PowerBI, SAP/DS, KNIME & SAP/BO Specialist
Cronos Intelligence for EC DG JUST