Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Section Access

When I am using section access what user name and password do I use for the reload from QMC?

Thanks

30 Replies
Clever_Anjos
Employee
Employee

Good to read that

tmumaw
Specialist II
Specialist II
Author

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
]
;
Section Application;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
732271, 732271
]
;

Okay.  ADMTEM should be able to see everything, and MUMAWT should only be able to see 732271 through Accesspoint.  Is there a reason why when ADMTEM signs on he only sees 732271, and MUMAWT see nothing.

Thanks

Clever_Anjos
Employee
Employee

Do you have

Star is *; 

in your script before the Section Access load?


Clever_Anjos
Employee
Employee

Further reading: Star ‒ QlikView

tmumaw
Specialist II
Specialist II
Author

Here is what I have.  Do I also have to put in the LinkTable *,* ?

STAR is *;
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
]
;
Section Application;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
732271, 732271
]
;

Clever_Anjos
Employee
Employee

No, you´re supposed to use it only once

tmumaw
Specialist II
Specialist II
Author

Here is my logic......  can you explain why I mumawt and admtem can only see 732271?  I'm confused.

STAR is *;

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
]
;
Section Application;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
120301, 120301
129905, 129905
130331, 130331
130531, 130531
130631, 130631
130831, 130831
131531, 131531
732271, 732271
732273, 732273
732275, 732275
732276, 732276
]
;

Clever_Anjos
Employee
Employee

Please make a small test

STAR is *;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
120301, 120301
129905, 129905
130331, 130331
130531, 130531
130631, 130631
130831, 130831
131531, 131531
732271, 732271
732273, 732273
732275, 732275
732276, 732276
]
;


Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
]
;
Section Application;

tmumaw
Specialist II
Specialist II
Author

No difference.

Clever_Anjos
Employee
Employee

Is is possible to send a sample of your app?