Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
christophebrault
Specialist
Specialist

Reducing data with fields

Hi,

I'm working on security in an app and i have to restrict data for each users. I've used access and application section with success, but i'm facing a problem.

How can i say for a user that all values are possible for the field ? I tired * with staris function but doesn't work...

Thanks

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
1 Solution

Accepted Solutions
Not applicable

I can confirm that you can use "*" with "star is *;" to say you want "every possible values".

Be sure you use CAPITALIZED letters in your groups for the "section access" part.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, GROUP_COUNTRY

    ADMIN , ADMIN, ADMIN, ALL

    USER, FRANCE, TEST, GRP_FR

    USER, USA, TEST, GRP_USA

    USER, ALL, TEST, ALL

];

Section Application;

star is *;

GROUP_COUNTRY:

LOAD * INLINE [

GROUP_COUNTRY, Country

ALL, *

GRP_FR, France

GRP_USA, USA

];

Country:

LOAD * INLINE [

Country, Value

France, 200

Germany, 300

Japan, 500

USA, 1000

];

2012-07-27_114057.png

---

2012-07-27_114137.png

---

2012-07-27_114207.png

View solution in original post

2 Replies
giakoum
Partner - Master II
Partner - Master II

check out page 18 of the attached doc. * works only if ALL values are listed in the Section Access conecrning that field.

read and you wil figure it out.

Not applicable

I can confirm that you can use "*" with "star is *;" to say you want "every possible values".

Be sure you use CAPITALIZED letters in your groups for the "section access" part.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, GROUP_COUNTRY

    ADMIN , ADMIN, ADMIN, ALL

    USER, FRANCE, TEST, GRP_FR

    USER, USA, TEST, GRP_USA

    USER, ALL, TEST, ALL

];

Section Application;

star is *;

GROUP_COUNTRY:

LOAD * INLINE [

GROUP_COUNTRY, Country

ALL, *

GRP_FR, France

GRP_USA, USA

];

Country:

LOAD * INLINE [

Country, Value

France, 200

Germany, 300

Japan, 500

USA, 1000

];

2012-07-27_114057.png

---

2012-07-27_114137.png

---

2012-07-27_114207.png