Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

trappersw
Contributor

Why doesn't this load? (Qlik Sense Section access)

Why doesn't this load in Qlik Sense server (it loads withing 20" when the section access and section application are commented)

Section access;

Security:

load *;

SQL SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

      union all

SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

           where isnumeric(substring([user_id],5,100))=0 and

         substring([user_id],5,100) like '%.%';

Concatenate

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER,         *

];

Section application;  

Securityapp:

load *;

SQL SELECT

       [KEY_AD_GROUP] as REDUCTION,

       key_business+'_'+key_market as BusinessMarket

FROM [WH_ID_EMEA].[cfg].[AD_Access];

1 Solution

Accepted Solutions

Re: Why doesn't this load? (Qlik Sense Section access)

Have you tried it this way?

Security:

SQL SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

      union all

SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

           where isnumeric(substring([user_id],5,100))=0 and

         substring([user_id],5,100) like '%.%';

CONCATENATE (Security)

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER,         *

];

Section access;

LOAD * RESIDENT Security;

Section Application;

...etc


talk is cheap, supply exceeds demand
1 Reply

Re: Why doesn't this load? (Qlik Sense Section access)

Have you tried it this way?

Security:

SQL SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

      union all

SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

           where isnumeric(substring([user_id],5,100))=0 and

         substring([user_id],5,100) like '%.%';

CONCATENATE (Security)

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER,         *

];

Section access;

LOAD * RESIDENT Security;

Section Application;

...etc


talk is cheap, supply exceeds demand