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: 
manoranjan_d
Specialist
Specialist

section access in qs

hi all below is my coding of qliksense which is not working fine for me, i have given access to me(X123456) as admin for all account as *, after runing and seeing the app it is not showing the app and getting as an access denied.

pls help me on this

SECURITY_USER_TABLE:

LOAD

    FIRSTNAME,

    "ACCESS" as ACCESS,

   'XO2\'& "USERID" as USERID,

    XLCOMPANYGUID

FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]

(qvd);

Concatenate

LOAD * INLINE [

FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID

QASERVICEACCOUNT1,ADMIN,X02\SADD02QlikSenseQA,

QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QlikSenseQA,

Manoranjan,ADMIN,RO2\X123456,*

Vignesh,ADMIN,RO2\X122756,*

Karan,ADMIN,RO2\X123410,*

];

SECTION ACCESS;

LOAD

UPPER(USERID) AS USERID,

UPPER(ACCESS) AS ACCESS,

UPPER(XLCOMPANYGUID) as XLCOMPANYGUID

Resident SECURITY_USER_TABLE;

SECTION APPLICATION;

Drop Table SECURITY_USER_TABLE;

6 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

You posted in "QlikView App Development"...

Posting a problem with Section Access in Qlik Sense in a QlikView forum is a bit weird.

Consider moving your question to an appropriate  Qlik Sense forum by following the steps listed here: QlikCommunity Tip: How to move your discussion thread

Anonymous
Not applicable

Hi Manoranjan,

Section access is not possible in QS Desktop version.

Sections access is possible in QS Server, STREAMS is a concept used in QS Server.

You need to create streams and give access to user of that streams.

Regards,

Rajan

manoranjan_d
Specialist
Specialist
Author

yes i m doing in the QS server only

Anonymous
Not applicable

See if this can help u..

Sections in the script ‒ Qlik Sense

You can achieve what you want by Streams also. i have  not worked on Section Access

Go through this https://community.qlik.com/message/797160?&_ga=2.226608792.442944211.1506512576-206219707.1505195290...

Regards,

Rajan Kasbe

agigliotti
Partner - Champion
Partner - Champion

try below code:

SECTION ACCESS;

LOAD

   UPPER(USERID) AS USERID,

   UPPER(ACCESS) AS ACCESS,

   UPPER(XLCOMPANYGUID) as XLCOMPANYGUID;

LOAD

    FIRSTNAME,

    "ACCESS" as ACCESS,

   'XO2\'& "USERID" as USERID,

    XLCOMPANYGUID

FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]

(qvd);

Concatenate

LOAD * INLINE [

FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID

QASERVICEACCOUNT1,ADMIN,X02\SADD02QLIKSENSEQA,

QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QLIKSENSEQA,

MANORANJAN,ADMIN,RO2\X123456,*

VIGNESH,ADMIN,RO2\X122756,*

KARAN,ADMIN,RO2\X123410,*

];

SECTION APPLICATION;

...

...


pradosh_thakur
Master II
Master II

Hi manoranjan

try this

STAR is *;

SECTION ACCESS;

LOAD

   UPPER(USERID) AS USERID,

   UPPER(ACCESS) AS ACCESS,

   UPPER(XLCOMPANYGUID) as XLCOMPANYGUID;

LOAD

    FIRSTNAME,

    "ACCESS" as ACCESS,

   'XO2\'& "USERID" as USERID,

    XLCOMPANYGUID

FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]

(qvd);

Concatenate

LOAD * INLINE [

FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID

QASERVICEACCOUNT1,ADMIN,X02\SADD02QLIKSENSEQA,

QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QLIKSENSEQA,

MANORANJAN,ADMIN,RO2\X123456,*

VIGNESH,ADMIN,RO2\X122756,*

KARAN,ADMIN,RO2\X123410,*

];

SECTION APPLICATION;




Please make sure Sevice account has ADMIN ACCESS and typed correctly because it is going to reload the data.

regards

Pradosh

Learning never stops.