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

Is publisher required to use REDUCTION in section access?

Hi,

I'm trying to reduce the data set that users are able to view based on their respective departments.  I've tried to use Section Access to limit this by using a REDUCTION field.  However upon testing the data sets are not being reduced as expected.  I am wondering if using reduction requires the publisher license?  Currently we have both the desktop and server license but not the publisher.

Also, I have loaded the section access with UPPER CASE in both the field name and the data.  However, the field and the data inside the dashboard are a combination of Upper and Lower case.  Would this be causing my issue?

Example load script:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, DEPARTMENT

    ADMIN, DOMAIN\ADMIN

    USER, DOMAIN\USER2, DEPT_TWO

    USER, DOMAIN\USER3, DEPT_THREE

    USER, DOMAIN\USER4, DEPT_FOUR

    USER, DOMAIN\USER5, DEPT_FIVE

];

Section Application;

Actual Dataset:

LOAD * INLINE [

    Department

    Dept_One

    Dept_Two

    Dept_Three

    Dept_Four

    Dept_Five

];

Any help would be greatly appreciated!

7 Replies
oknotsen
Master III
Master III

For "Data reduction based on section access" you do not need a Publisher license.

Field names and the data in the fields are CASE sensitive. To solve this issue, make a conversion table: Make a table with both DEPARTMENT and Department with the values you use in the Section Access table and the real values.

May you live in interesting times!
Anonymous
Not applicable
Author

Have you selected Initila Data Redusction based on section access in Document properties under opening tab??

Not applicable
Author

It appears I needed a combination of both the above responses.  In addition, I found that I needed to use an INLINE load of the Section Access as the load from .xlsx didn't seem to work (even with the UPPER() function?).  At any rate, thank you very much gentlemen!

vincent_ardiet
Specialist
Specialist

Hi Rick,

If you cannot read directly your XLSX, have you tried to first load it in a table outside the section access, and then use it in the section access with as a Resident? Of course don't forget to drop the first table before exiting the script.

Regards,

Vincent


avinashelite

Hi Rick,

You can do the data reduction in two ways using the QMC and SECTION ACCESS, If your using SECTION ACCESS no need if the QMC or Publisher. For Section access to work, all the data in section access need to be in Upper case if not you need to convert your data accordingly.

To answer your question"Section Access as the load from .xlsx" will definitely work ,  can you please share the file? or make sure your following all the rules .

qlikviewwizard
Master II
Master II

Watch this video Video - Section Access best practice

Section Access

Hope this will help you.

jonathandienst
Partner - Champion III
Partner - Champion III

Create a link between DEPARTMENT and Department like this:

Link:

LOAD Distinct Department,

     Upper(Department) As DEPARTMENT

Resident [Actual Dataset];

You could also create DEPARTMENT as a derived field when loading the fact table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein