Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

nicolas_martin
Contributor 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?



Community Browser