loading data base on user

Tue, 07 Feb 2017 09:09:30 GMT

I have a excel sheet which I loaded. If the value for user is 1, I will load the data for that.

First I load the excel control assess sheet as shown below

AccessControl:
LOAD UserID,
ENTITY,
VALUE
FROM
Access.xlsx
(ooxml, embedded labels, table is Sheet1);

Then i load the real data which contains entities like SIN, CN, AA and CN.

LOAD M_ENTITY,

FROM
[Data\LNBR_2016-09-30.xlsx]
(ooxml, embedded labels, table is DATA);

I use LET userID = QVUser(); to get the UserID which corresponds to the UserID in the excel sheet. For example, A9900899. Since A9900899 on the excel sheet has values 1 for SIN, CN and AA, i will load these data from the real data. But if the user who uses this application has UserID A1234567, only AA will be loaded.

How can I do this? Thanks

Re: loading data base on user

vinieme12 — Tue, 07 Feb 2017 09:24:20 GMT

please post sample data for both tables

Re: loading data base on user

vinieme12 — Tue, 07 Feb 2017 09:25:24 GMT

or read this

http://www.axisgroup.com/optimized-qvd-loads-caveats-for-using-the-exists-function/

topic Re: loading data base on user in QlikView

loading data base on user

Re: loading data base on user

Re: loading data base on user