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: 
cjzimm76
Partner - Creator
Partner - Creator

Section Access is not reducing data

I am using QV 11 and QVS 11 with publisher.  I am trying to reduce data using section access but when I open the dashboard (desktop or via Access Point) the date is not reduced.

Here is my code.

SECTION ACCESS;

LOAD * INLINE [
    ACCESS, NTNAME, PROJDIV
    ADMIN, IT\QLIKVIEW,
    ADMIN, IT\ABC, BS
    USER, IT\XYZ, GA
]
;
SECTION APPLICATION;

DivisionGroups:
LOAD * INLINE [
    GROUP, PROJDIV
     BDEV, GA
     G&A, GA
     IT, BS
     FS, BS
]
;

I go to Settings>Document Properties>Opening tab and check the check box for Initial Data Reduction Based on Section Access.  Hit Apply, then OK.  I save the document and then copy it to my QV Server.  I create a task to reload and publish the dashboard.  On the Reload tab of the task, I check the Section Access check box and enter the service account and password.  The task runs successfully.  But the data is not reduced.  Am I missing something?

And I did notice that when I go back into the Document Properties, that the check box for Initial Data Reduction Based on Section Access is no longer checked.  Why is that?

5 Replies
chematos
Specialist II
Specialist II

Check that the last chackbox is selected in Security menu at Document Properties and Strict Exclusion after Data Reduction Based on Section Access at Settings>Document Properties>Opening tab

What field you want to reduce??

cjzimm76
Partner - Creator
Partner - Creator
Author

I am trying to reduce the data on the PROJDIV field.

cjzimm76
Partner - Creator
Partner - Creator
Author

I found a section access example .qvw and I can get it to work.  But I take the code from the example .qvw file and put it into a new .qvw file to build it from scratch and it doesn't work.  But if I take my code from my .qvw and put it into the demo .qvw file it does work.  What could possibly be the difference in 2 files?  Either set of code works in one file, but neither works in another file.

In my file I still can't get the check box for Data Reduction Based on Section Access to stay checked.

cjzimm76
Partner - Creator
Partner - Creator
Author

I found the only difference between my file and the demo file to be the version of QV.  If I change my file back to V10, then it works.  Anyone have any idea what would need to be done to get it to work in V11?

Not applicable

I am having a similiar issue to this