Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
jleberre
New Contributor

Section access and resident load

Hello

I'm trying to perform data reduction. The security table, in the section access, load the data from a previously loaded table. But it locks my account. Using an inline table, it works.

I don't understand... Can someone help me?

My code:

// Data reduction

Input:
NoConcatenate
Load * Inline [
Access,Server,User,Country
ADMIN,QLIK,jleberre,FR
];

access:
NoConcatenate
Load
Access as ACCESS,
Server&'\'&User as USERID,
Country as REDUCTION,
'' as OMIT
Resident Input;

Drop Table Input;

Section Access;

Load
ACCESS,
USERID,
REDUCTION,
OMIT
Resident access;

// LOAD * Inline [
// ACCESS,USERID,REDUCTION,OMIT
// ADMIN,INTERNAL\SA_SCHEDULER,*,*,
// ADMIN,QLIK\jleberre,FR,
// ];

Section Application;

Drop Table access;

// Data model

Country:
NoConcatenate
Load * Inline [
Country,REDUCTION
France, FR
UnitedStates, US
];

Sales:
NoConcatenate
Load * Inline [
Product,Country,Sales
sweeat,France,10
sweat,UnitedStates,30
tshirt,France,20
tshirt,UnitedStates,60
jeans,France,30
jeans,UnitedStates,40
];

Thanks!

Labels (1)
1 Solution

Accepted Solutions
saar_lorena
New Contributor III

Re: Section access and resident load

Hi, Try to apply an UPPER() on userID.

3 Replies
saar_lorena
New Contributor III

Re: Section access and resident load

Hi, Try to apply an UPPER() on userID.

Partner
Partner

Re: Section access and resident load

every field used in a section access MUST be in UPPER case

jleberre
New Contributor

Re: Section access and resident load

Ok thank you!