Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

chauhans85
Esteemed Contributor

Section Access: all region not visible to admin access ?

Hi,

I have created a section access based on Region .

every thing is running fine but admin not able to see all region.

i mean when login with admin i.e sunil and password 1234 .it showing region field blank.

i dont know why this happening.

see the attached file.

Regards

Sunil

1 Solution

Accepted Solutions
Employee
Employee

Re: Section Access: all region not visible to admin access ?

The reason is that you use the USERID as reducing field.Try instead using REGION as reducing field:

Section Access;

star is *;

Tab1:

LOAD upper(Access) as ACCESS,

     upper(USERID) as USERID,

     Upper(Password) as PASSWORD

     FROM test21.xlsx (ooxml, embedded labels, table is Sheet1);

Tab2:

LOAD

          Upper(USERID) as USERID,

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2);

Section Application;

Tab3:

LOAD

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2) Where Len(Trim(Region))>1;

HIC

2 Replies
chauhans85
Esteemed Contributor

Re: Section Access: all region not visible to admin access ?

any help on this?

Employee
Employee

Re: Section Access: all region not visible to admin access ?

The reason is that you use the USERID as reducing field.Try instead using REGION as reducing field:

Section Access;

star is *;

Tab1:

LOAD upper(Access) as ACCESS,

     upper(USERID) as USERID,

     Upper(Password) as PASSWORD

     FROM test21.xlsx (ooxml, embedded labels, table is Sheet1);

Tab2:

LOAD

          Upper(USERID) as USERID,

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2);

Section Application;

Tab3:

LOAD

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2) Where Len(Trim(Region))>1;

HIC