topic Section ACCESS QUERY in QlikView

Section ACCESS QUERY

hariprasad_koya — Wed, 25 Nov 2020 16:16:04 GMT

Dear Team,

I have written a section access code in the attached QVW and below is my query regarding this.

i have a transactional data at 2 Companycodes-IN01,IN02 and INDIA data is not there in the transactional table and i need to generate using INA+INB and i have done it using INLINE Table

i want the below requirement regarding the section access.

For ADMIN,the data should show up only for INA,INB,INDIA(Company Name)

For CAN,the data should show up only for INA

For USA,the data should show up only for INB

You can open the QVW using the below credentials.

USERID : ADMIN

Password : ADMIN

Kindly provide the solution .

Thanks,

Hari

Re: Section ACCESS QUERY

hariprasad_koya — Sun, 12 Mar 2017 07:36:56 GMT

Dear Team,

Kindly request to respond as it is very urgent sceanrio.

Regards,

Hari

Re: Section ACCESS QUERY

maxgro — Sun, 12 Mar 2017 09:25:55 GMT

try this

Star is *;

Section Access;

LOAD * INLINE [

ACCESS,USERID,PASSWORD, COMPANYNAME

ADMIN,ADMIN,ADMIN, INA

ADMIN,ADMIN,ADMIN, INB

ADMIN,ADMIN,ADMIN, INDIA

USER,CAN,CAN, INA

USER,USA,USA, INB

];

Section Application;

CompanyMaster:

LOAD *, CompanyName as COMPANYNAME

inline [

CompanyNo,CompanyCode,CompanyName

1,IN01,INA

2,IN02,INB

3,IN01,INDIA

4,IN02,INDIA

];

// remove USERID

LOAD CompanyCode,Value

inline [

USERID,CompanyCode,Value

CAN,IN01,1000

USA,IN02,2000

];

Re: Section ACCESS QUERY

muthukumar77 — Mon, 13 Mar 2017 05:40:16 GMT

Refer this app,