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 - How to prevent data been reduced/deleted from a hierarchy table

Hi everybody,

my situation is the following:

I have several reference/dimension tables with texts in my datamodel. These texts are often a part of a hierarchy and have no connection to the data table itself, just some of the values.

When I now use section access within the document, the mechanism also reduces the reference table with the texts and my hierarchy does not fully exists anymore.

How can I prevent the data reduction on the dimension/hierarchy tables?

star is *;

section access;

LOAD * Inline [

ACCESS,USERID,PASSWORD,COLUMN1

admin,admin,admin,1

];

section Application;

H1:

Hierarchy(Code,ParentCode, Text,,Text,Tree)

load * inline [

Code, ParentCode, Text

ALL,,ALLE TEXTE

A,ALL,TEXT_A

B,ALL,TEXT_B

C,ALL,TEXT_C

D,ALL,TEXT_D

Aa,A,TEXT_Aa];

Data:

load * inline [

COLUMN1,COLUMN2,Code

1,1,Aa

1,2,B

1,3,C];

4 Replies
stantrolav
Partner - Creator II
Partner - Creator II

How this thing (in your sample) connected with section access? In your example 1 user ADMIN can see all the data from tables. I don't see any reducing.

IAMDV
Luminary Alumni
Luminary Alumni

Hi Susann,

Is this issue resolved?

Cheers,

DV

www.QlikShare.com

Not applicable
Author

Hi Deepak,

no it's not. It's still an issue.

Best regards

Susann

tresesco
MVP
MVP

Have a look at this post: hierarchy-authorization