Section access not working using qvd in qlik sense
Hello All,
I have a security table in DB which contains user details and their associated products and accounts. For testing purpose they added my username as user in the table. I have created an excel file and gave my name as admin and some values into product and accounts field. In app i loaded the qvd and concatenated the excel file and applied section access. I see only the products and codes which are from excel but not from the qvd. No user was able to access the report even their details are present in the security table. For test purpose I have included some of the users into the excel with products and codes and they were able to see only the excel codes and products.
Below are the steps created in my app:
load table from DB and converted rows to columns
concatenated excel to the transformed table
Script:
star is *;
section access;
load
ACCESS,
USERID,
PRODUCT,
ACCOUNT
FROM security_table.QVD WHERE 1=1;
SECTION APPLICATION;
ACCOUNT:
LOAD
*
from TABLE A ; (Table A is already existing dimension table which contains accounts)
PRODUCT:
LOAD
*
FROM TABLE B; ( Table B is already existing dimension table which contains products)
