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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Star is

Hello
long time I haven't used the STAR is  
I'm trying to recall its usage now
correct me if I'm wrong

Section Access;

Securtity:
load * Inline [
ACCESS,USERID, REDUCTION_FIELD
USER, DOMAIN/USER1, <ANY>
USER, DOMAIN/USER2, A
USER, DOMAIN/USER2, B
USER, DOMAIN/USER2, C
];

Section Application;

FACT:
load * inlin [
REDUCTION_FIELD, DATE
A, JAN-2024
B, FEB-2024
C, MAR-2024
D, MAR-2024
...

];

Does this mean that USER1 seas data related to A,B,C, and D?
If not, then what is the approach to make USER1 see data to any value under the reduction field?

I can walk on water when it freezes
Labels (1)
1 Solution

Accepted Solutions
Ben_P
Creator II
Creator II

STAR IS defines the wildcard used in section access.

So if you specify e.g. STAR IS %; then you can use the % character in your section access to mean 'all listed values'.

If you specify just STAR IS; with no character, that means that no wildcard character is applicable.

Star | QlikView Help

 

In your example, this would give USER1 access to A, B, C (but not D as it's not listed in the section access):

STAR IS *;

Section Access;

Security:
load * Inline [
ACCESS,USERID, REDUCTION_FIELD
USER, DOMAIN/USER1, *
USER, DOMAIN/USER2, A
USER, DOMAIN/USER2, B
USER, DOMAIN/USER2, C
];

... in order for USER1 to see D, you'd need to do something like adding a dummy permission so that D is listed, e.g. an extra line in the section access:

USER, DUMMY_USER, D

View solution in original post

3 Replies
Ben_P
Creator II
Creator II

STAR IS defines the wildcard used in section access.

So if you specify e.g. STAR IS %; then you can use the % character in your section access to mean 'all listed values'.

If you specify just STAR IS; with no character, that means that no wildcard character is applicable.

Star | QlikView Help

 

In your example, this would give USER1 access to A, B, C (but not D as it's not listed in the section access):

STAR IS *;

Section Access;

Security:
load * Inline [
ACCESS,USERID, REDUCTION_FIELD
USER, DOMAIN/USER1, *
USER, DOMAIN/USER2, A
USER, DOMAIN/USER2, B
USER, DOMAIN/USER2, C
];

... in order for USER1 to see D, you'd need to do something like adding a dummy permission so that D is listed, e.g. an extra line in the section access:

USER, DUMMY_USER, D

ali_hijazi
Partner - Master II
Partner - Master II
Author

you didn't answer my question
what do you mean by all listed values?

I can walk on water when it freezes
Ben_P
Creator II
Creator II

All values that are listed in the section access. I've edited my post above to give an example.