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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolas_martin
Partner - Creator II
Partner - Creator II

Section access and filter without link

Hello,

I have a problem with the section access when some data are not linked to a possible value.

Let's say I have a table "data1" with data possibly linked to a country, and another table "data2" linked to this items:

Data1:

LOAD * INLINE [

id, country, item

1, France, France is a country

2, France, Eiffel Tower

3, USA, New York

];

Data2:

LOAD * INLINE [

comment, id

Something linked to France, 1

Something linked to New York, 3

Something linked to nothing,

];

I made a section access to restrict data for users:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, GRP_COUNTRY

    ADMIN, all1, ALL

    ADMIN, all2,

    ADMIN, all3, *

    ADMIN, france, FRANCE

];

Section Application;

star is *;

GRP_COUNTRY:

LOAD * INLINE [

GRP_COUNTRY, country

ALL, *

FRANCE, France

USA, USA

];

On QlikView Desktop, if I open the application with "all1" user or "all3" user, I can see:

2016-06-17_164218.jpg

On QlikView Desktop, if I open the application with "all2", I can see:

2016-06-17_164201.jpg

On the web client, if I open the application with "all1" user or "all3" user, I can see the same thing as in the QlikView Desktop.

On the web client, if I open the application with "all2"... I can't.


First question: why the behavior is different between web client and desktop client?


Second question : how can I have a user that can access to ALL data, even the ones not linked to the field I use as restriction?



0 Replies