Section access not working using qvd in qlik sense

dandaanilreddy — Thu, 22 Apr 2021 18:15:43 GMT

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)

Please can someone help me to resolve this ?

Thanks

topic Re: Section access not working using qvd in qlik sense in App Development

Section access not working using qvd in qlik sense

Re: Section access not working using qvd in qlik sense