Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Section ACCESS QUERY

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

3 Replies
Highlighted
Contributor III
Contributor III

Re: Section ACCESS QUERY

Dear Team,

Kindly request to respond as it is very urgent sceanrio.

Regards,

Hari

Highlighted
MVP
MVP

Re: Section ACCESS QUERY

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

];

Highlighted
Partner
Partner

Re: Section ACCESS QUERY

Refer this app,

Muthukumar Pandiyan