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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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?