Discussion Board for collaboration related to QlikView Deployment.
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.
Go to Solution.
The reason is that you use the USERID as reducing field.Try instead using REGION as reducing field:
star is *;
LOAD upper(Access) as ACCESS,
upper(USERID) as USERID,
Upper(Password) as PASSWORD
FROM test21.xlsx (ooxml, embedded labels, table is Sheet1);
Upper(USERID) as USERID,
Upper(Region) as REGION
FROM test21.xlsx (ooxml, embedded labels, table is Sheet2);
FROM test21.xlsx (ooxml, embedded labels, table is Sheet2) Where Len(Trim(Region))>1;
any help on this?