Section access and filter without link

nicolas_martin — Fri, 17 Jun 2016 14:50:01 GMT

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:

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

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?

topic Section access and filter without link in QlikView

Section access and filter without link