Discussion board where members can get started with Qlik Sense.
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?
// Data reduction
Input:NoConcatenateLoad * Inline [Access,Server,User,CountryADMIN,QLIK,jleberre,FR];
access:NoConcatenateLoadAccess as ACCESS,Server&'\'&User as USERID,Country as REDUCTION,'' as OMITResident Input;
Drop Table Input;
// LOAD * Inline [// ACCESS,USERID,REDUCTION,OMIT// ADMIN,INTERNAL\SA_SCHEDULER,*,*,// ADMIN,QLIK\jleberre,FR,// ];
Drop Table access;
// Data model
Country:NoConcatenateLoad * Inline [Country,REDUCTIONFrance, FRUnitedStates, US];
Sales:NoConcatenateLoad * Inline [Product,Country,Salessweeat,France,10sweat,UnitedStates,30tshirt,France,20tshirt,UnitedStates,60jeans,France,30jeans,UnitedStates,40];
Go to Solution.
Hi, Try to apply an UPPER() on userID.
every field used in a section access MUST be in UPPER case
Ok thank you!